I have around 1600 Name along with company
name,Address1,Address2,City,State,Pincode

For Ex:

Mr.hardeep Kanwar
Bi/200
Yamuna Vihar
Dehi
110053

Some times it has 5data as mentioned in the Example, Sometime4 and sometimes 6

And in the end of every data there is a Blank Row

Like This
Mr.hardeep Kanwar
Bi/200
Yamuna Vihar
Dehi
110053
Blank
Ms. Danielle Fran
American Cancer Society
1555 Abbey Road
East Lansing, MI 48823
Blank

Now i want to Convert like this

Mr.hardeep Kanwar Bi/200 Yamuna Vihar Dehi 110053
Ms. Danielle Fran American Cancer Society 1555 Abbey Road East Lansing, MI
48823

But Without using Marco.



Any Help will be Highly Appreciate

Hardeep Kanwar