The Excel TRANSPOSE Function

Basic Description

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.


Transpose Function Examples

Example 1

Example of use of the Excel Transpose Function

In the above spreadsheet 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

Example of use of the Excel Transpose Function

In the above 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.


More examples of the Excel Transpose function are provided on the Microsoft Office website.