The TRANSPOSE function transposes (rotates) a range of cells.
We can transpose our data by using the relevant Paste Special option also but it will create duplicate data.
The syntax of the function is the following:
TRANSPOSE(array)
array: the range of cells to transpose
TRANSPOSE is an array function so its usage is a bit different.
We select a blank area of our worksheet which will have the size of our data after they are transposed. So, if we want to transpose a 5×2 cell range we select a 2×5 cell range.
Having these blank cells selected we type the function.
For the function to work we have to press CTRL+SHIFT+ENTER after typing the formula.
You can watch our tutorial for more info.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the TRANSPOSE function:
Transpose the cell area A1:H1 to the cell area J1:J8 using the proper Excel formula.