Documentation/Calc Functions/TRANSPOSE

Function name:
TRANSPOSE

Category:
Array

Summary:
Transposes the rows and columns of an array.

Syntax:
TRANSPOSE(Array)

Arguments:
Array represents the array in the spreadsheet that is to be transposed.

You can find a general introduction to using Array functions on top of this page.

Examples:
In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press Shift + Ctrl + Enter. Or, if you are using the Function Wizard, mark the Array check box. The transposed array appears in the selected target range and is protected automatically against changes.

The above table is 2 rows, 4 columns. In order to transpose it, you must select 4 rows, 2 columns. Assuming you want to transpose the above table to the range A7:B10 (4 rows, 2 columns) you must select the entire range and then enter the following:

TRANSPOSE(A1:D2)

Then make sure to enter it as matrix formula with Shift + Ctrl + Enter. The result will be as follows: