Rotating Tables (Transposing)

In LibreOffice Calc, there is a way to "rotate" a spreadsheet so that rows become columns and columns become rows.

  1. Select the cell range that you want to transpose.

  2. Choose Edit - Cut.

  3. Click the cell that is to be the top left cell in the result.

  4. Choose Edit - Paste Special.

  5. In the dialog, mark Paste all and Transpose.

    If you now click OK the columns and rows are transposed.

If this page has been helpful, you can support us!