A Andrew Mar 27, 2009 #1 Are there ways to swap the contents in the rows and the columns? ie. A1 B1 --> A1 A2 A2 B2 --> B1 B2 Thanks.
Are there ways to swap the contents in the rows and the columns? ie. A1 B1 --> A1 A2 A2 B2 --> B1 B2 Thanks.
B Bill Kuunders Mar 27, 2009 #2 copy the range go to a new sheet paste special...........tick transpose
R ryguy7272 Mar 28, 2009 #3 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---
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---
