One way:

Assume your data starts in cell A1:

=INDEX($A:$A,ROW(A1)*10-10+COLUMN(A1))

Copy across 10 columns then down until you you get returns of 0. (assuming
you have empty cells at the end of the data list)

Then you can do a CopyPaste SpecialValues to convert the formulas to
constants.

Biff

"G Lykos" wrote in message
...
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