# Documentation/Calc Functions/TRANSPOSE

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

TRANSPOSE

Array

## Summary:

Transposes the rows and columns of an array.

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.

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