The Excel TRANSPOSE Function

Custom Search

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

The format of the function is :

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.

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