Manuals/calci/MATRIXTRANSPOSE

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

See Also

References

Transpose