Difference between revisions of "Documentation/How Tos/Calc: TRANSPOSE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 16: | Line 16: | ||
<br style="clear:both;" /> | <br style="clear:both;" /> | ||
| − | + | {{Documentation/SeeAlso| | |
| − | [[Documentation/How_Tos/Calc: MDETERM function| | + | * [[Documentation/How_Tos/Calc: MDETERM function|MDETERM]], |
| − | [[Documentation/How_Tos/Calc: MINVERSE function| | + | * [[Documentation/How_Tos/Calc: MINVERSE function|MINVERSE]], |
| − | [[Documentation/How_Tos/Calc: MMULT function| | + | * [[Documentation/How_Tos/Calc: MMULT function|MMULT]], |
| − | [[Documentation/How_Tos/Calc: MUNIT function| | + | * [[Documentation/How_Tos/Calc: MUNIT function|MUNIT]] |
| − | [[Documentation/How_Tos/Using Arrays| | + | * [[Documentation/How_Tos/Using Arrays|How To Use Arrays in Calc]] |
| − | [[Documentation/How_Tos/Calc: Array functions| | + | * [[Documentation/How_Tos/Calc: Array functions|Array functions]] |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 14:23, 25 February 2009
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.
