mxtranspose
Syntax:
Return
Range
mxtranspose
(
Range
matrix1)
Description:
Computes the matrix transpose of
matrix1
and places it at the current cell.
Examples:
($a4) = mxtranspose($a1:$c3)
Before:
A
B
C
D
1
1
4
7
2
2
5
8
3
3
6
20
4
5
6
After:
A
B
C
D
1
1
4
7
2
2
5
8
3
3
6
20
4
1
2
3
5
4
5
6
6
7
8
20
($a2) = mxtranspose($a1:$d5)