I have following two columns of data in excel 2007:
a 1
b 2
...
What I need to swap the view to:
a b ...
1 2 ...
I think there is way to do it in excel 2007. Is this possible?
I have following two columns of data in excel 2007:
a 1
b 2
...
What I need to swap the view to:
a b ...
1 2 ...
I think there is way to do it in excel 2007. Is this possible?
No VBA programming necessary.
Just Copy, Paste Special, then check the "transpose" box.