From 578e1e320daaa82b2d3b8c0eeea84bf704967939 Mon Sep 17 00:00:00 2001 From: Joel Madero Date: Wed, 26 Oct 2016 13:02:16 -0700 Subject: tdf#103397 - added example for Transpose function Added a simple example to the help for transpose() function Added tablehead style to example rows/columns Change-Id: I464983d480cb237a53e033005057a1faef0b9193 Reviewed-on: https://gerrit.libreoffice.org/30334 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/scalc/01/04060107.xhp | 123 +++++++++++++++++++++++++++++++++++++- 1 file changed, 120 insertions(+), 3 deletions(-) diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index 3a8e01487d..842121ad92 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -575,7 +575,7 @@ Syntax MDETERM(Array) Array represents a square array in which the determinants are defined. -You can find a general introduction to using Array functions on top of this page. +You can find a general introduction to using Array functions on top of this page. @@ -632,11 +632,128 @@ Syntax TRANSPOSE(Array) 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. Example 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+Command+Enter 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+Command+Enter +Shift+Ctrl+Enter. The result will be as follows: + + + + + + + A + + + B + + + + + 7 + + + 2 + + + 6 + + + + + 8 + + + 3 + + + 7 + + + + + 9 + + + 4 + + + 8 + + + + + 10 + + + 5 + + + 9 + + +
@@ -1145,4 +1262,4 @@
- \ No newline at end of file + -- cgit