Difference between revisions of "Manuals/calci/TRANSPOSE"

Latest revision as of 12:47, 15 August 2018

TRANSPOSE (Range,MakeLengthEqual)

is the array of values to transpose.
- TRANSPOSE(), returns the transpose of an array.

This function is used to copy the data displaying in vertical order in to a horizontal order or copy the data displaying in horizontal order in to a vertical order.
In $TRANSPOSE(Range,MakeLengthEqual)$ , $Range$ is the range of cells to be transfer from column in to a row or row in to a column.
The result as a horizontal range of cells if a vertical range of cell is given as a argument.
The result as a vertical range of cells if a horizontal range of cell is given as a argument.

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''TRANSPOSE(ar)'''</div><br/>
+<div style="font-size:30px">'''TRANSPOSE (Range,MakeLengthEqual)'''</div><br/>
-*<math>ar </math>  is the array of values to transpose.
+*<math>Range</math>  is the array of values to transpose.
+**TRANSPOSE(), returns the transpose of an array.
 ==Description==
 *This function is used to copy the data displaying in vertical order in to a horizontal order or copy the data displaying in horizontal order in to a vertical order.
-*In <math> TRANSPOSE(ar)</math>, <math>ar </math> is the range of cells to be transfer from column in to a row or row in to a column.
+*In <math> TRANSPOSE (Range,MakeLengthEqual)</math>, <math>Range</math> is the range of cells to be transfer from column in to a row or row in to a column.
 *The result as a horizontal range of cells if a vertical range of cell is given as a argument.
 *The result as a vertical range of cells if a horizontal range of cell is given as a argument.
@@ Line 48: / Line 49: @@
 |July || 2 || 1 || 4
 |}
+==Related Videos==
+{{#ev:youtube|2t0003_sxtU|280|center|TRANSPOSE}}
 ==See Also==
@@ Line 56: / Line 61: @@
 ==References==
 [http://en.wikipedia.org/wiki/Transpose Transpose ]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]