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

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 of use of the Excel Transpose Function

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.

Example of use of the Excel Transpose Function

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

Return to the Excel Lookup & Reference Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net