Difference between revisions of "Manuals/calci/TRANSPOSE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TRANSPOSE'''(Array) where, '''Array''' - represents an array having same number of rows and columns. ...") |
|||
| Line 1: | Line 1: | ||
| + | <div style="font-size:30px">'''TRANSPOSE(ar)'''</div><br/> | ||
| + | *<math>ar </math> is the array of values to transpose. | ||
| + | |||
| + | |||
| + | ==Description== | ||
| + | *This function is used to copy the data displaying in vertical order in to a horizontal order or copy the data displaying in horizontal order in to a vertical order. | ||
| + | *In <math> TRANSPOSE(ar), ar </math> is the range of cells to be transfer from column in to a row or row in to a column. | ||
| + | *The result as a horizontal range of cells if a vertical range of cell is given as a argument. | ||
| + | *The result as a vertical range of cells if a horizontal range of cell is given as a argument. | ||
| + | |||
| + | |||
| + | ==Examples== | ||
| + | April May June July | ||
| + | Sony 8 5 3 2 | ||
| + | Roy 7 9 5 1 | ||
| + | Vivek 10 0 2 4 | ||
| + | TRANSPOSE(B1:F4)= | ||
| + | Sony Roy Vivek | ||
| + | April 8 7 10 | ||
| + | May 5 9 0 | ||
| + | June 3 5 2 | ||
| + | July 2 1 4 | ||
| + | {| class="wikitable" | ||
| + | |+Spreadsheet | ||
| + | |- | ||
| + | ! !! A !! B !! C !! D!! E | ||
| + | |- | ||
| + | ! 1 | ||
| + | | ||April || May || June ||July | ||
| + | |- | ||
| + | ! 2 | ||
| + | | Sony || 8 || 5 || 3 || 2 | ||
| + | |- | ||
| + | ! 3 | ||
| + | | Roy || 7 || 9 || 5 || 1 | ||
| + | |- | ||
| + | ! 4 | ||
| + | |Vivek || 10 || 0 || 2 ||4 | ||
| + | |} | ||
| + | |||
| + | |||
| + | |||
<div id="6SpaceContent" class="zcontent" align="left"> | <div id="6SpaceContent" class="zcontent" align="left"> | ||
| Line 31: | Line 73: | ||
Lets see an example in (Column2, Row4) | Lets see an example in (Column2, Row4) | ||
| − | + | UNIQce542110ff34cf12-nowiki-00000002-QINU | |
TRANSPOSE returns [1,2,6]. | TRANSPOSE returns [1,2,6]. | ||
Revision as of 00:08, 3 February 2014
TRANSPOSE(ar)
- is the array of values to transpose.
is the array of values to transpose.
Description
- This function is used to copy the data displaying in vertical order in to a horizontal order or copy the data displaying in horizontal order in to a vertical order.
- In is the range of cells to be transfer from column in to a row or row in to a column.
- The result as a horizontal range of cells if a vertical range of cell is given as a argument.
- The result as a vertical range of cells if a horizontal range of cell is given as a argument.
is the range of cells to be transfer from column in to a row or row in to a column.
Examples
April May June July
Sony 8 5 3 2 Roy 7 9 5 1 Vivek 10 0 2 4 TRANSPOSE(B1:F4)=
Sony Roy Vivek
April 8 7 10 May 5 9 0 June 3 5 2 July 2 1 4
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | April | May | June | July | |
| 2 | Sony | 8 | 5 | 3 | 2 |
| 3 | Roy | 7 | 9 | 5 | 1 |
| 4 | Vivek | 10 | 0 | 2 | 4 |
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)
?UNIQce542110ff34cf12-nowiki-00000002-QINU?
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 |
