\<bookmark_value\>tables; transposing\</bookmark_value\>\<bookmark_value\>transposing tables\</bookmark_value\>\<bookmark_value\>inverting tables\</bookmark_value\>\<bookmark_value\>swapping tables\</bookmark_value\>\<bookmark_value\>columns; swap with rows\</bookmark_value\>\<bookmark_value\>rows; swapping with columns\</bookmark_value\>\<bookmark_value\>tables; rotating\</bookmark_value\>\<bookmark_value\>rotating; tables\</bookmark_value\>

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 \<emph\>Edit - Cut\</emph\>.

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

  4. Choose \<emph\>Edit - Paste Special\</emph\>.

  5. In the dialog, mark \<emph\>Paste all\</emph\> and \<emph\>Transpose\</emph\>.

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