# Excel TRANSPOSE Function

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.

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

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.