Tag Archives: TRANSPOSE

How to Transpose cells in Excel

Kornilios Ampatzis/ April 5, 2019/ Tutorials

It is certain that at some point everybody needs to alter the form and layout of their data, in order for them to be more readable, or answer to some specific visual requirements.
The ability to transpose our data is such a need.

The TRANSPOSE Function

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.