Copy-- then Edit--Paste special--Transpose
You may need to paste it to a new worksheet.
************
Anne Troy
www.OfficeArticles.com

"Edward Chambers" wrote in
message ...
Does anyone know an automated way to get data that is listed in cells
going
down the page (vertically) into cells that go across the page
(horizontally)?

For example:

Name Randy
Address 10 Apple Road
City Anytown
State CA
Zip 90001

Would become:
Name Address City State Zip
Randy 10 Apple Road Anytown CA 90001

I've been wondering this for years!!

Thanks,

Edward