Remove extra lines

[sksanjeev786]

Hi Team,

Need help removing extra line

book2
	A	B	C	D
1	Input			Output
2	I shop at this retailer because I like the Home Care section			I shop at this retailer because I like the Home Care section
3	Provides low prices on Home Care products, even if there's no promotion			Provides low prices on Home Care products, even if there's no promotion
4	Offers a good selection of Home Care products that meet my needs			Offers a good selection of Home Care products that meet my needs
5				This retailer understands my needs when it comes to Home Care products
6				Offers good value for the money for Home Care products
7	This retailer understands my needs when it comes to Home Care products			Helps me take good care of myself/my family when shopping for Home Care products
8	Offers good value for the money for Home Care products			Home Care products on promotion are consistently in stock
9				Offers a good selection of the latest Home Care products
10				Provides the information I need at shelf in the Home Care section to help me select the right products
11	Helps me take good care of myself/my family when shopping for Home Care products			The store shelves in the Home Care section are organized and easy to shop
12	Home Care products on promotion are consistently in stock			Offers a good selection of name brand Home Care products
13	Offers a good selection of the latest Home Care products			Has good sales/promotions on Home Care products
14	Provides the information I need at shelf in the Home Care section to help me select the right products			Offers a good selection of Home Care products across price points
15				Offers a good selection of natural Home Care products
16				Search results for Home Care are relevant
17				The products on promotion help me decide to shop this retailer for Home Care products
18	The store shelves in the Home Care section are organized and easy to shop			The Home Care section inspires me to explore and try new products
19	Offers a good selection of name brand Home Care products			Offers a good selection of Home Care products that I can only find at this retailer
20	Has good sales/promotions on Home Care products			Offers a good selection of Home Care products online
21	Offers a good selection of Home Care products across price points			Offers high quality store brands within the Home Care section
22	Offers a good selection of natural Home Care products
23	Search results for Home Care are relevant
24	The products on promotion help me decide to shop this retailer for Home Care products
25	The Home Care section inspires me to explore and try new products
26	Offers a good selection of Home Care products that I can only find at this retailer
27	Offers a good selection of Home Care products online
28	Offers high quality store brands within the Home Care section
29
30
31
32
33
34
Sheet1

Thanks in adavane
Sanjeev

 

[Peter_SSs]

If your data is not too large, try this with a copy of your workbook.

Sub Del_Lines()
  Columns("A").SpecialCells(xlBlanks).EntireRow.Delete
End Sub

 

[sksanjeev786]

If your data is not too large, try this with a copy of your workbook.

Sub Del_Lines()
  Columns("A").SpecialCells(xlBlanks).EntireRow.Delete
End Sub

Thanks you so much Peter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.