revert table

A

agenda9533

Is it possible to revert excel table - to revert rows in columns and columns
in rows.
Example,
A 2 3 4
B
C
REVERTS to
A B C
2
2
4

Thank you!
 
A

alMandragor

mark the area;
right-click;
click "Pase Special";
mark "Transpose";
click ok
 
A

alMandragor

ups.. forgot something:

mark the area;
CTRL + C (copy it);
right-click where you want it reverted;
click "Paste Special";
mark "Transpose";
click ok
 
Top