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:
- array: An array or a range you want to transpose.
- 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.
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.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL ADDRESS Function
- EXCEL AREAS Function
- EXCEL CHOOSE Function
- EXCEL COLUMN Function
- EXCEL COLUMNS Function
- EXCEL FORMULATEXT Function
- EXCEL HLOOKUP Function
- EXCEL HYPERLINK Function
- EXCEL INDEX Function
- EXCEL INDIRECT Function
- EXCEL LOOKUP Function
- EXCEL MATCH Function
- EXCEL OFFSET Function
- EXCEL ROW Function
- EXCEL ROWS Function
- EXCEL VLOOKUP Function
About the Author
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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.