How to swap the contents rows and columns in a spreadsheet?

[Andrew]

Are there ways to swap the contents in the rows and the columns?
ie.
A1 B1 --> A1 A2
A2 B2 --> B1 B2
Thanks.

 

[Bill Kuunders]

copy the range
go to a new sheet
paste special...........tick transpose

 

[ryguy7272]

Transpose will do it! Here are some ideas:
http://www.techonthenet.com/excel/formulas/transpose.php

http://blogs.techrepublic.com.com/msoffice/?p=630

http://www.timeatlas.com/mos/5_Minute_Tips/General/How_to_Switch_Excel_Columns_and_Rows/


HTH,
Ryan---