revert table
 

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!

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

"agenda9533" wrote:

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!

ups.. forgot something:

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


"alMandragor" wrote:

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

"agenda9533" wrote:

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!