Transpose convert columns to rows macro for excel

[Closed]
Report
Posts
1
Registration date
Saturday February 28, 2015
Status
Member
Last seen
February 28, 2015
-
Issue

I have huge data in a single column & each data group is seprated by single empty cell




For Example :


Company Name 1
Address
Conatact Person
Mobile No
ETC


Company Name 2
Address
Conatact Person
Mobile No
Moblie No 2
Website

As Much as Company Data or any Other Data we can add


and would like to transpose it into a row like...



Please help me with a column to row macro... which can do this job for me


Thank you So Much