The
TRANSPOSE() function transforms the
rows of an array into columns and the
columns into rows.
- The syntax for the function
is TRANSPOSE(array).
The
argument "array" can
be an array of numerical values, references
to a range of cells or a named range of
which you want to find a transpose.
The
TRANSPOSE function uses a systematic process
of re-alocating array elements to convert
columns to rows ans rows to columns. For
example TRANSPOSE(A1,A2,A3) ={B1,C1,D1}.
The cell A1 becomes B1, cell A2 becomesC1
and cell A3 becomes D1 the effect of which
is to covert a column of cells into a row
of cells. The function can also convert rows
into columns. When the TRANSPOSE function
is used with square arrays it has the effect
of flipping the array along its diagonal,
turning rows into colums and columns into
rows. e.g. TRANSPOSE({1,2,3;4,5,6;7,8,9})={1,4,7;2,5,8;3,6,9}.
To learn more about
transposing matrices or "arrays" in
mathematics see: [The Transposing Matrices
Mathematics Knowledgebase].
[The
MMULT() function knowledgebase]
[The
MINVERSE() function knowledgebase]
[The MDETERM() function knowledgebase]
|
