Oops again. You have to select B1 before doing the Paste Special thing, not
A1! Once everything is deleted, you must then delete Col A.
--
Hth

Kassie Kasselman


"G Lykos" wrote:

Greetings! Have an Excel database that has ten lines per entry in one
column in a symmetric structure - first line is name, second line is
address, etc. Would like to rotate the data so each entry is one row, with
the lines in successive columns 1, 2, etc. Can this be accomplished using
standard worksheet functions? If not, is there some code available?

Thanks,
George