Convert rows to columns

[Matt483]

I have a spreadsheet with all the information in rows like this:

1 First Name
2 Last Name
3 Address
4 Phone Number

I would like to convert it so it ends up in columns like this:

A------------------B-----------------C----------------D
First Name Last Name Address Phone Number

I would have possibly hundreds of rows that I would like to convert to columns. This is to be able to import it into another software program.

Any ideas on a quick way to accomplish this?

Thanks.

[jrkrideau]

[Matt483]

Thanks that works perfectly!