TRANSPOSE function

This article describes the formula syntax and usage of the TRANSPOSE function in Microsoft Excel. Find a link to more information about transposing data in the See Also section.


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.



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. If you're not sure of how to enter an array formula, see Enter an array formula.


Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.









Live Result


Value from A2 transposed into a different cell.



Value from B2 transposed into a different cell, and below the value from A2 instead of to its right.



Value from C2 transposed into a different cell, and below the value from B2 instead of to its right.


See Also

Transpose (rotate) data from rows to columns or vice versa

Enter an array formula

Rotate or align cell data

Guidelines and examples of array formulas

Applies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Online, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel Starter, Excel for Android phones

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language