Hi there,
I have a group of rows and want to transpose them to a columns.

say I have column of address
(four rows,
Address,
city,
state
zip) and each address is saperated by blank rows.
I want to transpose each address into a column. Is there a way to do this in
excell?


wilde wood ave
Lake land
FL
90010

Little rock rd
San diago
CA
92345


Result after transpose

wilde wood ave Lake land FL 90010
Little rock rd San diago CA 92345




any help appricated.

Thanks
-Murali