The Excel TRANSPOSE Function

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

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.

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

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.

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

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.

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.


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