From The Document Foundation Wiki
- . Select the table area to be transposed.
- . Select ▸ (Ctrl+X) or also (Ctrl+C).
- . Click on the cell that will become the top left cell in the result.
- . Select ▸ ▸ .
- . In the dialog, select the "Paste All" and "Transpose" options or click on the button.