Rotate Excel table (transpose)

Rotate Excel table (transpose)

An Excel table has the following structure and should be rotated:

Table 1
Column A.
Column B
Bernd
01.01.1980
Franz
02.02.1970

The magic word is "Transpose"and rotates copied tables.
To make the table look like Excel table 2, proceed as follows:

Table 2
Column A.
Column B
Bernd
Franz
01.01.1980
02.02.1970

Mark and copy the cells of the table. Select cells> right mouse button> insert content, set the option "Transpose" in the following window and confirm with OK.

Questions about Office or especially Excel click here.

more interesting Excel tips:


____________________________________________________
This tip / article is from www.win-tipps-tweaks.de
© Copyright Michael Hille / Chainon Kittisonthirak

Warning:
Using Registry Editor or its tips incorrectly can cause serious problems that may require you to reinstall the
Require operating system.
Tampering with the registry files and using the tips is at your own risk.