TRANSPOSE

Flip the orientation of a range of cells

Sponsored Link

TRANSPOSE

Purpose 

Flip the orientation of a range of cells

Return value 

An array in a new orientation.

Syntax 

=TRANSPOSE (array)

Arguments 

  • array - The array or range of cells to transpose.

Usage notes 

The TRANSPOSE function converts a vertical range of cells to a horizontal range of cells, or a horizontal range of cells to a vertical range of cells. Use it to "flip" a range of cells from one orientation to another.

When array is transposed, the first row of array is used as the first column of the new array, the second row of array is used as the second column of the new array, the third row of array is used as the third column of the new array, and so on.

You must enter the TRANSPOSE function as an array formula that contains same number of cells as array, using Control + Shift + Enter.

The new array must occupy the same number of rows as the source array has columns, and the same number of columns as the source array has rows.

For a one-off conversion, you can use paste special > transpose.

Sponsored Link

0 votes. 0 / 5