It really depends on how many records you have. If not too many, you can
select the ten rows, press <Ctrl<C, select the first cell, right click,
select Paste Special, and tick the Transpose option and OK out. Row 1 - 10
will become row 1, Col A:J. You will then have to delete rows 2-10, and
repeat the whole excercise. Alternatively, you can achieve the exact same
result with a macro, which takes a while to code, but does the job a lot
quicker.
--
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