Transpose Tables in Calc

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
Deutsch • ‎English

Foreword

Table marked
"Paste Special" dialog
Table transposed

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

Diese Beschreibung bezieht sich auf die LibreOffice-Versionen.

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 Columns and Rows.

No problem, you can help by transposing tables ( Swap Columns and Rows ).

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 Edit ▸ Cut - ( Ctrl + X or also Ctrl + C ).
  3. . Click on the cell that will become the top left cell in the result.
  4. . Select Edit ▸ Paste Special ▸ Paste Special….
  5. . In the dialog, select the "Paste All" and "Transpose" options or click on the Transpose All button.

If you now click on the OK button, Columns and Rows will be swap.

Further Informations

Work files

Work table

"Tabelle umkehren - transponieren.ods"

Description as document

"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

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.