Documentation/Calc Functions/TRANSPOSE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

TRANSPOSE

Category:

Array

Summary:

Transposes the rows and columns of an array.

Syntax:

TRANSPOSE(Array)

Returns:

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.

Additional details:

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.

A B C D
1 2 3 4 5
2 6 7 8 9

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:

A B
7 2 6
8 3 7
9 4 8
10 5 9

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: