Manuals/calci/TRANSPOSE - Revision history

Devika at 18:47, 15 August 2018

2018-08-15T18:47:53Z

Devika at 18:46, 15 August 2018

2018-08-15T18:46:39Z

Jayaram at 12:22, 14 March 2017

2017-03-14T12:22:37Z

Swapna at 20:20, 30 June 2015

2015-06-30T20:20:51Z

Abin at 08:48, 5 February 2014

2014-02-05T08:48:49Z

Abin at 06:44, 5 February 2014

2014-02-05T06:44:21Z

Devika: /* Examples */

2014-02-03T06:20:07Z

Examples

Devika at 06:18, 3 February 2014

2014-02-03T06:18:33Z

Devika at 06:08, 3 February 2014

2014-02-03T06:08:22Z

MassBot1: Created page with "
'''TRANSPOSE'''(Array) where, '''Array''' - represents an array having same number of rows and columns. ..."

2013-10-25T02:46:19Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TRANSPOSE'''(Array) where, '''Array''' - represents an array having same number of rows and columns. ..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''TRANSPOSE'''(Array)

where,

'''Array''' - represents an array having same number of rows and columns.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

It returns a horizontal range of cells as vertical range, or vice versa.

</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

If Array have same number of rows and columns.

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

TRANSPOSE

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

Lets see an example in (Column2, Row4)

<nowiki>=TRANSPOSE(R1C1:R3C1)</nowiki>

TRANSPOSE returns [1,2,6].

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
| Column1
| Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class=" " | 1
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class=" " | 2
|
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" " | 6
|
| class=" " |
| class=" " |
|- class="even"
| Row4
| class=" " |
| class="sshl_f" | 1,2,6
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class=" " |
| class="sshl_f SelectTD ChangeBGColor SelectTD" |
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
| class=" " |
| class=" " |
|- class="even"
| Row6
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''TRANSPOSE (Range,MakeLengthEqual)'''</div><br/>
 *<math>Range</math>  is the array of values to transpose.
 ==Description==

@@ 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.
 ==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.

← Older revision		Revision as of 12:22, 14 March 2017
Line 60:		Line 60:
	==References==		==References==
	[http://en.wikipedia.org/wiki/Transpose Transpose ]		[http://en.wikipedia.org/wiki/Transpose Transpose ]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 48: / Line 48: @@
 |July || 2 || 1 || 4
 |}
 ==See Also==

@@ Line 5: / Line 5: @@
 *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.
-*The result as a horizontal range of cells if a vertical range of cell  is given as a argument.
+*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 11: / Line 11: @@
 ==Examples==
 {| class="wikitable"
 |+Spreadsheet
@@ Line 43: / Line 33: @@
 |+Spreadsheet
 |-
-! !! A !! B !! C !! D!! E
+! !! A !! B !! C !! D
 |-
 ! 1
@@ Line 60: / Line 50: @@
 |July || 2 || 1 || 4
 |}
 ==See Also==

@@ Line 15: / Line 15: @@
 Roy      7            9            5             1
 Vivek   10          0            2             4
-TRANSPOSE(B1:F4)=
              Sony     Roy    Vivek
 April      8            7           10
@@ Line 39: / Line 39: @@
 |}
+#TRANSPOSE(A1:E4)=
+{| class="wikitable"
-<div id="6SpaceContent" class="zcontent" align="left">
+|+Spreadsheet
+|-
-'''TRANSPOSE'''(Array)
+! !! A !! B !! C !! D!! E
+|-
-where,
+! 1
+| ||Sony || Roy || Vivek
-'''Array''' -  represents an array having same number of rows and columns.
+|-
+! 2
-</div>
+| April || 8 || 7 || 10
-----
+|-
-<div id="1SpaceContent" class="zcontent" align="left">
+! 3
+| May || 5 || 9 || 0
-It returns a horizontal range of cells as vertical range, or vice versa.
+|-
+! 4
-</div>
+|June || 3 || 5 || 2
-----
+|-
-<div id="7SpaceContent" class="zcontent" align="left">
+!5
+|July || 2 || 1 || 4
-If Array have same number of rows and columns.
+|}
-Lets see an example in (Column2, Row4)
+==See Also==
-<div align="left">[[Image:calci1.gif]]</div></div>
+==References==

@@ Line 1: / Line 1: @@
 <div id="6SpaceContent" class="zcontent" align="left">
@@ Line 31: / Line 73: @@
 Lets see an example in (Column2, Row4)
-<nowiki>=TRANSPOSE(R1C1:R3C1)</nowiki>
+UNIQce542110ff34cf12-nowiki-00000002-QINU
 TRANSPOSE returns [1,2,6].