Manuals/calci/TRANSPOSE

TRANSPOSE(ar)

• $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 $TRANSPOSE(ar),ar$ 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

           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

1. TRANSPOSE(A1:E4)=

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

• MDETERM
• MINVERSE
• MMULT