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

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

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

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

--
Greetings from New Zealand
"Andrew" wrote in message
...
Are there ways to swap the contents in the rows and the columns?
ie.
A1 B1 -- A1 A2
A2 B2 -- B1 B2
Thanks.

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

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

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

http://www.timeatlas.com/mos/5_Minut...umns_and_Rows/


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Bill Kuunders" wrote:

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

--
Greetings from New Zealand
"Andrew" wrote in message
...
Are there ways to swap the contents in the rows and the columns?
ie.
A1 B1 -- A1 A2
A2 B2 -- B1 B2
Thanks.