Skip to main content

TRANSPOSE

Definition

Transposes the rows and columns of an array or range of cells.

Sample Usage

TRANSPOSE(Jan, 100, Feb, 200, Mar, 150, Apr, 300)

TRANSPOSE(A1:C2)

Syntax

TRANSPOSE(array_or_range)

  • array_or_range - The array or range whose rows and columns will be swapped.

Notes

  • Transposition operates such that the value in the nth row and mth column will become the value in the mth row and nth column. E.g. the value in the fourth row and second column will be put into the second row and fourth column. The result of a transposition on a range of size m rows by n columns is therefore n rows by m columns.

In order to use the TRANSPOSE formula, start with your edited Excellentable:

  1. Highlight the empty cells you wish to transpose onto. If you are transposing vertical cells, you will need to select the exact number of cells horizontally and vice versa.   


  2.  Type in "=TRANSPOSE(". 


  3. Select and drag the range of cells you wish to transpose. Then close the formula.  


  4. Press Ctrl + Shift + Enter. 


A
B
C
D
1
Array
Jan
100
2
Feb
200
3
Mar
150
4
Apr
300
5
6
7
Transpose
Jan
Feb
Mar
8
100
200
150
E
1
2
3
4
5
6
7
Apr
8
300

See also 

MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.

MINVERSE: Returns the multiplicative inverse of a square matrix specified as an array or range.

MDETERM: An array or range with an equal number of rows and columns representing a matrix whose determinant will be calculated.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.