Difference between revisions of "Manuals/calci/MATRIXTRANSPOSE"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 31: Line 31:
 
|7.6 || 87
 
|7.6 || 87
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=TZrKrNVhbjI|280|center|Matrix Transpose}}
  
 
==See Also==
 
==See Also==

Latest revision as of 11:50, 25 April 2019

MATRIXTRANSPOSE (a)


  • is any matrix.

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 any matrix.
  • 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

1. MATRIXTRANSPOSE([[12,17,18],[6,15,36],[13,19,25]])

12 6 13
17 15 19
18 36 25

2. MATRIXTRANSPOSE([[5,19,-36,10,7.6],[20,-17,4.5,43,87]])

5 20
19 -17
-36 4.5
10 43
7.6 87

Related Videos

Matrix Transpose

See Also

References

Transpose