Menu
EXCEL TRANSPOSE FUNCTION
Excel TRANSPOSE Function Introduction
This function changes the vertical range of a cell to the horizontal range of a cell and the horizontal range of a cell to the vertical range of a cell and returns an array in the new orientation. Because this is an array function, after selecting and putting this formula into the cells where you want the new values to be pasted, press Ctrl+Shift+Enter.
Description of Excel TRANSPOSE Function
Syntax:
=TRANSPOSE (array)
Parameter list:
- array – the array of cells to be transposed.
- The generated array must have the same number of rows as the source array and the same number of columns as the original array.
Step By Step Guide of TRANSPOSE Function
Example :
In this example, we must first pick the cell range F1:J4 (you should select 5 columns since there are 5 rows to convert and 4 rows because there are 4 columns to convert). Enter the formula =TRANSPOSE(A1:D5) and press Ctrl+Shift+Enter to convert to array formula and transpose the columns and rows.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
