﻿ TRANSPOSE function

# TRANSPOSE function

## Description

The TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa. The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet.

## Syntax

TRANSPOSE(array)

The TRANSPOSE function syntax has the following argument:

• array    Required. An array or range of cells on a worksheet that you want to transpose. The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on.

## Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

 Data 1 2 3 Formula Description Live Result =TRANSPOSE(\$A\$2:\$C\$2) Value from A2 transposed into a different cell. 1 =TRANSPOSE(\$A\$2:\$C\$2) Value from B2 transposed into a different cell, and below the value from A2 instead of to its right. 2 =TRANSPOSE(\$A\$2:\$C\$2) Value from C2 transposed into a different cell, and below the value from B2 instead of to its right. 3 To examine or change the array formula in C4:C6, you must open this workbook in the Excel desktop program. Download the workbook by clicking View full-size workbook in the Microsoft Excel Web App bar at the bottom of this page, click Open in Excel above the worksheet grid on the page that appears, and then download the workbook to your computer. Press Ctrl+Shift+Enter to see the results of the array formula.

Applies To: Excel 2010, Excel Starter, Excel 2013, Excel Online, Excel 2016 for Mac, Excel for Mac 2011, Excel 2007

﻿