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

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.