Difference between revisions of "Manuals/calci/TRANSPOSE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(4 intermediate revisions by 4 users not shown)
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==
 
==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.  
 
*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 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.  
 
*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
 
|July || 2 || 1 || 4
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|2t0003_sxtU|280|center|TRANSPOSE}}
  
 
==See Also==
 
==See Also==
Line 56: Line 61:
 
==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 ]]

Latest revision as of 13:47, 15 August 2018

TRANSPOSE (Range,MakeLengthEqual)


  • 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 , 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.

Examples

Spreadsheet
A B C D E
1 April May June July
2 Sony 8 5 3 2
3 Roy 7 9 5 1
4 Vivek 10 0 2 4
  1. TRANSPOSE(A1:E4)=
Spreadsheet
A B C D
1 Sony Roy Vivek
2 April 8 7 10
3 May 5 9 0
4 June 3 5 2
5 July 2 1 4

Related Videos

TRANSPOSE

See Also

References

Transpose