writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 15:
Line 15: − TRANSPOSE(B1:F4)=+ Line 39:
Line 39: − + − + − <div id="6SpaceContent" class="zcontent" align="left">+ − + − '''TRANSPOSE'''(Array)+ − + − where,+ − + − '''Array''' - represents an array having same number of rows and columns.+ − + − </div>+ − ----+ − <div id="1SpaceContent" class="zcontent" align="left">+ − + − It returns a horizontal range of cells as vertical range, or vice versa.+ − + − </div>+ − ----+ − <div id="7SpaceContent" class="zcontent" align="left">+ − + − If Array have same number of rows and columns.+ − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − TRANSPOSE − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − Lets see an example in (Column2, Row4)+ + + + − UNIQce542110ff34cf12-nowiki-00000002-QINU − − TRANSPOSE returns [1,2,6]. − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class=" " | 1 − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | class=" " | Row2 − | class=" " | 2 − | − | class=" " | − | class=" " | − |- class="odd" − | Row3 − | class=" " | 6 − | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class=" " | − | class="sshl_f" | 1,2,6 − | class=" " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" " | − | class="sshl_f SelectTD ChangeBGColor SelectTD" | − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div> − | class=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |} − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----
Manuals/calci/TRANSPOSE (view source)
Revision as of 06:18, 3 February 2014
, 06:18, 3 February 2014no edit summary
Roy 7 9 5 1
Roy 7 9 5 1
Vivek 10 0 2 4
Vivek 10 0 2 4
Sony Roy Vivek
Sony Roy Vivek
April 8 7 10
April 8 7 10
|}
|}
#TRANSPOSE(A1:E4)=
{| class="wikitable"
|+Spreadsheet
|-
! !! A !! B !! C !! D!! E
|-
! 1
| ||Sony || Roy || Vivek
|-
! 2
| April || 8 || 7 || 10
|-
! 3
| May || 5 || 9 || 0
|-
! 4
|June || 3 || 5 || 2
|-
!5
|July || 2 || 1 || 4
|}
==See Also==
*[[Manuals/calci/MDETERM | MDETERM ]]
*[[Manuals/calci/MINVERSE | MINVERSE ]]
*[[Manuals/calci/MMULT | MMULT ]]
==References==