Kornilios Ampatzis/ April 5, 2019/ Functions

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:

Practice

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.

Share this Post