T
Teethless mama
Select your range > right click Copy > select your destination cell, right
click paste special > Transpose > OK out
click paste special > Transpose > OK out
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
Have you tried either the TRANSPOSE function or Copy/Paste Special/
Transpose ?
Transpose ?
J
jreinier
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.
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.
J
jreinier
Thanks! I really appreciate you responses. Worked great!