The Excel TRANSPOSE Function

Home » Excel-Built-In-Functions » Excel-Transpose-Function

Search this site:

Custom Search

The Excel TRANSPOSE function 'transposes' an array of cells (ie. the function copies a horizontal range of cells into a vertical range and vice versa).

Array Formulas:

To input an array formula, you need to first highlight the range of cells for the function result. Type your function into the first cell of the range, and press CTRL-SHIFT-Enter.

Go to the Excel Array Formulas page for more details.

The format of the function is :

TRANSPOSE( Array )

Where the Array argument is a range of Excel spreadsheet cells.

As the transpose function returns an array of values, it must be entered as an Array Formula.

Example 1 In the example on the right, the simple vertical range of cells A1 - A6 is transposed into the horizontal range B1 - F1. The formula for the function can be seen in the formula bar. The curly braces { } show that the function has been input as an Array Formula.
Example 2 In the spreadsheet on the right, the range of cells A1 - D2 is transposed into the range F1 - G4. Again the curly braces { } shown in the formula bar indicate that the function has been input as an Array Formula.