Columns to Rows?

[xcellnoob]

I did a search and couldn't find anything related, so:
Is there a way to Take a column of data and paste it so that it's a row?
So basically, column A I want to be in Row 1. Horizontal versus vertical.
Help?

 

[chearn]

you should be able to copy your column info then "paste special" and click on transpose, that will put your column info into a row

 

[Oaktree]

Also consider the TRANSPOSE function if you want it to be linked instead of copied/pasted values.

Note: to transpose a 2x3 rectangle, select a 3x2 range, enter =TRANSPOSE(2x3 range's addresses) and press CTRL+SHIFT+ENTER. You have to select the range first, and you have to enter with CSE.