Difference between revisions of "Manuals/calci/MATRIXTRANSPOSE"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''MATRIXTRANSPOSE (a) '''</div><br/> *<math>a </math> is any matrix. ==Description== *This function is used to copy the data displaying in vertic...") |
|||
| Line 9: | Line 9: | ||
==Examples== | ==Examples== | ||
| + | 1. MATRIXTRANSPOSE([[12,17,18],[6,15,36],[13,19,25]]) | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | | 12 || 6 || 13 | ||
| + | |- | ||
| + | | 17 || 15 || 19 | ||
| + | |- | ||
| + | | 18 || 36 || 25 | ||
| + | |} | ||
| + | 2. MATRIXTRANSPOSE([[5,19,-36,10,7.6],[20,-17,4.5,43,87]]) | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | | 5 || 20 | ||
| + | |- | ||
| + | |19 || -17 | ||
| + | |- | ||
| + | | -36 ||4.5 | ||
| + | |- | ||
| + | | 10 || 43 | ||
| + | |- | ||
| + | |7.6 || 87 | ||
| + | |} | ||
==See Also== | ==See Also== | ||
Revision as of 14:49, 6 July 2017
MATRIXTRANSPOSE (a)
- is any matrix.
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