Documentation/How Tos/Calc: TRANSPOSE function

CALC FUNCTIONS

Arrays Functions

< Previous Section

Next Section >

FUNCTIONS

• Frequency
• Growth
• Linest
• Longest
• Mdeterm
• Minverse
• Mmult
• Munit
• Sumproduct
• Sumx2my2
• Sumx2py2
• Sumxmy2
• Transpose
• Trend

< Previous Page

Next Page >

TRANSPOSE

Returns an array with its rows and columns transposed.

Syntax:

TRANSPOSE(array)

array may be either an inline array or a range, containing all numbers.

TRANSPOSE must be entered as an array formula (for example by using Cntrl-Shift-Enter rather than just Enter).

Example:

=TRANSPOSE({1;2;3|4;5;6})

when entered as an array formula in cell B3, returns {1;4|2;5|3;6}, so that cells B3, C3 show 1, 4, cells B4, C4 show 2, 5 and cells B4, C4 show 3, 6 respectively.

---

See Also

• MDETERM
• MINVERSE
• MMULT
• MUNIT

• How To Use Arrays in Calc

• Array functions

• Functions listed alphabetically
• Functions listed by category