The Excel TRANSPOSE Function

Function Description

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

The syntax of the function is:

TRANSPOSE( array )

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

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

Inputting Array Formulas

To input an array formula in Excel:

1. Highlight the range of cells for the function result;
2. Type the function into the first cell of the range, and press CTRL-SHIFT-Enter.
See the Excel Array Formulas page for more details.

Transpose Function Examples

Example 1 In the above spreadsheet on the right, the simple vertical range of cells A1-A6 is transposed into the horizontal range B1-F1.

As shown in the formula bar, the formula for the function is:

=TRANSPOSE( A1:A6 )

The curly braces { } show that the function has been input as an Array Formula.

Example 2 In the above spreadsheet on the right, the range of cells A1-D2 is transposed into the range F1-G4.

In this case, the formula for the function is:

=TRANSPOSE( A1:D2 )

Again the curly braces { } shown in the formula bar indicate that the function has been input as an Array Formula.

For further examples of the Excel Transpose function, see the Microsoft Office website.