Difference between revisions of "Documentation/How Tos/Calc: TRANSPOSE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→Example:: added image) |
(→See also:) |
||
Line 26: | Line 26: | ||
[[Documentation/How_Tos/Calc: Array functions|'''Array functions''']] | [[Documentation/How_Tos/Calc: Array functions|'''Array functions''']] | ||
+ | |||
+ | [[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']], | ||
+ | [[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']] |
Revision as of 17:42, 11 September 2008
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
Functions listed alphabetically, Functions listed by category