T Teethless mama May 8, 2008 #1 Select your range > right click Copy > select your destination cell, right click paste special > Transpose > OK out
Select your range > right click Copy > select your destination cell, right click paste special > Transpose > OK out
D David Biddulph May 8, 2008 #2 Have you tried either the TRANSPOSE function or Copy/Paste Special/ Transpose ?
J jreinier May 8, 2008 #3 I would like to swap the data in an Excel spreadsheet by changing the columns to rows, and the rows to columns, For example: This: 1 2 3 Would become this: 1 4 7 4 5 6 2 5 8 7 8 9 3 6 9 Is this possible, and if so how can I do it? I have a large amount of data and performing this by hand would take an extreme amount of time. Any assistance you can provide would be appreciated.
I would like to swap the data in an Excel spreadsheet by changing the columns to rows, and the rows to columns, For example: This: 1 2 3 Would become this: 1 4 7 4 5 6 2 5 8 7 8 9 3 6 9 Is this possible, and if so how can I do it? I have a large amount of data and performing this by hand would take an extreme amount of time. Any assistance you can provide would be appreciated.
