Difference between revisions of "Manuals/calci/TRANSPOSE"

From ZCubes Wiki
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)
  
<nowiki>=TRANSPOSE(R1C1:R3C1)</nowiki>
+
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.


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.


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

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


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