Try entering the references for the first two lines:

A01 A02 A03 A04 A05 A06 A07 A08 A09
A11 A12 A13 A14 A15 A16 A17 A18 A19

(As a shortcut enter only the first cell and drag the lower right
corner right.)
Then select this 2 x 10 block and drag the fill handle, in the lower
right corner down, as far as is needed followed by Edit Replace "A"
with "=A"

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