Manuals/calci/TRANSPOSE

From ZCubes Wiki
Revision as of 03:48, 5 February 2014 by Abin (talk | contribs)
Jump to navigation Jump to search
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

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
  1. TRANSPOSE(A1:E4)=
Spreadsheet
A B C D
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

References

Transpose