Try copy then paste special/transpose.
Will

"ktfrubel" wrote:

covert an entire spreadsheet from a column format to a row format?

I have a spreadsheet that was given to me that has about 1150 entries. The
format that the came to was:

Name
Address
City State
Zip

The format I need to get is

Name Address CityState Zip

Is there a way to change this in one fast way instead of having to copy
paste special each one?