Syntax: @TRANSPOSE(M)
M = a matrix
@TRANSPOSE generates the transpose of the numeric matrix M.
Examples:
Matrix B9..C10
B | C | |
9 | 1 | 3 |
10 | 2 | 4 |
@TRANSPOSE(B9..C10) =
1 | 2 |
3 | 4 |
Matrix A1..B4 =
A | B | |
1 | 0.99 | 0 |
2 | 3 | 6.2 |
3 | 4.1 | 1.1 |
4 | 3.3 | 6.3 |
@TRANSPOSE(A1..B4) =
.99 | 3 | 4.1 | 3.3 |
0 | 6.2 | 1.1 | 6.3 |
@TRANSPOSE(B17) = Error - improper argument type