Have a look in help index for TRANSPOSE

--
Don Guillett
SalesAid Software

"Dennis_Kesselring" wrote in
message ...
Once again I find myself needing to do something in Excel that I know
SHOULD
be possible, but have never figured out HOW. I've captured meaningful data
as
text and pasted it in Excel. First row is "name", second row is "address",
third row is "city", fourth row is blank and then the fifth row starts
with
the next record's "name". My need and desire is to rotate this data so
that
column one is "name", column two is "address", column three is "city" and
each row is a separate record.

Assistance please!
Thanks!!