/text/scalc/guide/table_rotate.xhp Sun Microsystems, Inc. tables; transposing transposing tables inverting tables swapping tables columns; swap with rows rows; swapping with columns tables; rotating rotating; tables Rotating Tables (Transposing) In $[officename] Calc, there is a way to "rotate" a spreadsheet so that rows become columns and columns become rows. Select the cell range that you want to transpose. Choose Edit - Cut. Click the cell that is to be the top left cell in the result. Choose Edit - Paste Special. In the dialog, mark Paste all and Transpose. If you now click OK the columns and rows are transposed.

Paste Special