Manuals/calci/TRANSPOSE
Jump to navigation
Jump to search
TRANSPOSE(Array)
where,
Array - represents an array having same number of rows and columns.
It returns a horizontal range of cells as vertical range, or vice versa.
If Array have same number of rows and columns.
TRANSPOSE
Lets see an example in (Column2, Row4)
=TRANSPOSE(R1C1:R3C1)
TRANSPOSE returns [1,2,6].
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 1 | |||
Row2 | 2 | |||
Row3 | 6 | |||
Row4 | 1,2,6 | |||
Row5 | ||||
Row6 |