Hello everyone,
since I am a beginner, this is probably a very simple question - but searching for 'transpose table', 'rotate table', 'rows to columns' didn't yield any useful results for me.
So my question is: How can you rotate a table that the orientation is transposed?
E.g. if I have a table with 3 columns and many rows
A | 1 | 9
B | 2 | 8
C | 3 | 7
D | 4 | 6
E | 5 | 5
F | 6 | 4
... | ... | ...
How can I turn it into:
A | B | C | D | E | F | ...
1 | 2 | 3 | 4 | 5 | 6 | ....
9 | 8 | 7 | 6 | 5 | 4 | ....
And vice versa?
I have tried to play around with crosstab and transpose - these didn't yield the desired results though.
For crosstab I wish there was the possibility to select multiple "Data fields".
Solved! Go to Solution.
LOL - great minds think alike, though in my case 4 minutes slower :-)
There ought to be a rotate table tool