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 |
