Excel tutorials

If you have a sheet arranged like below, adding more and more data into it would become hard to maintain.

A better approach would be to arrange the above into columns. Luckily we dont have to do this manually. There is a feature called Transpose that we can use.

Follow the below steps to transform the above rows to columns.

• Select all the data – including headers
• Press CTRL+C
• Right-click on the cell where you want the data to be.
• Under Paste Options. select Transpose
• We can delete the original data if we want to.

As we can see, this is much more readable.