TRANSPOSE Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc TRANSPOSE, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
Array transposition. Exchanges the rows and columns of an array. The test matrix contains rows [2,1] and [1,3]. The output swaps rows and columns; INDEX selects two known elements to check.
Syntax and arguments
=TRANSPOSE(Array)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
Array |
The array in which the rows and columns have been transposed. |
Worked examples
Reproduce these source cells: Q10=2, R10=1, Q11=1, R11=3.
Full array output: FILTER, SORT and matrix functions may need a selected output range and Ctrl+Shift+Enter in LibreOffice Calc. The examples below return one scalar result that was tested directly.
Example 1: Transpose a matrix before selecting one result
=INDEX(TRANSPOSE(Q10:R11);2;1)
Expected result: 1. This value was returned in the LibreOffice Calc 25.2 test.
Example 2: Retrieve a transposed matrix element
=INDEX(TRANSPOSE(Q10:R11);1;2)
Expected result: 1. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
The test matrix contains rows [2,1] and [1,3]. The output swaps rows and columns; INDEX selects two known elements to check.
Mistakes and troubleshooting
- Check inputs and assumptions: When entering the entire output, select a correctly sized destination and use an array formula as required.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.