writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Line 31:
Line 73: − <nowiki>=TRANSPOSE(R1C1:R3C1)</nowiki>+
Manuals/calci/TRANSPOSE (view source)
Revision as of 06:08, 3 February 2014
, 06:08, 3 February 2014no edit summary
<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">
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].