Videos/Transpose Table/en

Foreword








The video shows how you can make columns into rows and rows into columns in a table in Calc and links to this page here, which provides more information and details.

This description is based on the Help of LibreOffice

This description refers to the version LibreOffice 7.0 under Windows 10.

Link to the Video
Link to the Video (in German [DE]):

Tabelle - Spalten und Zeilen tauschen

Tables transpose
You have already started your table and now you realize it would be better if you could swap rows and columns.

No problem, you can help by transposing tables (swap).

To swap columns and rows
LibreOffice Calc offers the possibility to transpose (swap) spreadsheets so that rows become columns and columns become rows.

This is called "transposing".


 * 1) . Select the table area to be transposed.
 * 2) . Select - ( +  or also  + ).
 * 3) . Click on the cell that will become the top left cell in the result.
 * 4) . Select.
 * 5) . In the dialog, select the "Paste All" and "Transpose" options or click on the button.

If you now click on the button, columns and rows will be rotated.

Work table
[[Media:Tabelle umkehren - transponieren.ods|"Tabelle umkehren - transponieren.ods"]]

Description as document
[[Media:Tabelle umkehren - transponieren.odt|"Tabelle umkehren - transponieren.odt"]]

Documentation / Manuals
Here you will find the Documentation / Manuals:

Documentation / Manuals

Any questions?
For questions on this topic go to:

Ask.LibreOffice

Get Involved
Join us today and help us to make it even better!

Get Involved

Donate
LibreOffice is Free Software and is made available free of charge.

Your donation, which is purely optional, supports our worldwide community.

If you like the software, please consider a Donation.