next up previous contents index
Next: TREND Up: A. Function Reference Previous: TODAY   Contents   Index


TRANSPOSE

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

Excel function: TRANSPOSE


next up previous contents index
Next: TREND Up: A. Function Reference Previous: TODAY   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003