Formulas and functions > Functions from A to Z > TRANSPOSE (transpose matrix)

Syntax:

TRANSPOSE(Array)

Description:

Returns the transpose of a matrix, i.e., swaps its columns with its rows. When you transpose, for example, a 2x4 matrix, the result is a 4x2 matrix.

Array is a cell range or array containing the matrix to be evaluated.

Note:

Formulas using this function have to be entered as an array formula. For more information, see Working with arrays.

Please note that the range you have to select before entering the formula must have the correct dimensions. If the matrix consists of x rows and y columns, the resulting range must have y rows and x columns.

Example:

TRANSPOSE({1,2,3;4,5,6}) returns {1,4;2,5;3,6}