# Documentation/Calc Functions/TRANSPOSE

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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 |