Manuals/calci/TRANSPOSE

From ZCubes Wiki
Revision as of 21:46, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TRANSPOSE'''(Array) where, '''Array''' -  represents an array having same number of rows and columns. ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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