Excel TRANSPOSE Function

HomeExcel FunctionsExcel TRANSPOSE Function (Example + Sample File)

What is EXCEL TRANSPOSE FUNCTION

The Excel TRANSPOSE Function is listed under Microsoft Excel's Lookup Functions category. It changes the orientation of a range. In simple words, by using this function you can change the data from a row into a column and from a column into a row.

How to use it

To learn how to use the TRANSPOSE function in Excel, you need to understand its syntax and arguments:

Syntax

TRANSPOSE (array)

Arguments

  • array: An array or a range you want to transpose.

Notes

  • You have to apply TRANSPOSE as an array function, using the same number of cells as you have in your source range by pressing Ctrl + Shift + Enter.
  • If you select cells less than source range, it will transpose data only for those cells.

Example

To master the TRANSPOSE function we need to try it out in an example, so make sure to check out the below one:

Here we need to transpose data from range B2:D4 to range G2 to I4:

  • For this, first, we need to go to the cell G2 and select cell range up to I4.
  • Next is to enter (=TRANSPOSE(B2:D4)) in cell G2 and press Ctrl+Shift+Enter.

TRANSPOSE will convert the data from the rows into columns, and the formula which we have applied is an array formula, you cannot change a single cell from it.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.