Exceljet

Quick, clean, and to the point

Excel TRANSPOSE Function

Excel TRANSPOSE function
Summary 

The Excel TRANSPOSE function "flips" the orientation of a given range or array. TRANSPOSE converts a vertical range to a horizontal range, or a horizontal range to a vertical range. You must enter the TRANSPOSE function as an array formula.

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.
Version 
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.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.