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