You are currently viewing How to transpose columns to rows in Excel

How to transpose columns to rows in Excel

The choice of what values to appear on the column or the rows may be a challenge especially when we are dealing with sensitive data. You may choose the column header of a particular data set but find that the column header would have been better being used on the side of the rows.

This problem or issue may arise when you are almost done or you are done with your work of data recording in the excel sheet. This situation can cause distress to the one doing the work of recording the data. However, thanks to excel in-built functions and tools you can transpose the columns to rows.

To transpose is the act of rotation or turning the columns to be on the side where the rows have been and the rows to rotate where the columns originally were. With this function, you do not have to delete or start over again once you make the row to column mistake or error.

To do the transpose follow the steps below as they are discussed in depth.

Step 1

Open an excel sheet from the computer and record the columns and rows of your choice and insert some values into them.

Step 2

With the above data set, we need to transpose the columns to rows. First of all, select the entire data set and click on copy to have the entire data set copied. Place your cursor to the new location where you want your new data set to be located.

Step 3

On the new location where your cursor is, click on paste from the home tab. Choose the paste option and click on transpose to rotate the columns to rows. The paste option does rewrite the first data set but now in a different line and a different format.

The transpose function has worked out successfully and the columns have been transposed to rows. This process is time-saving unlike manual deleting and starting over again once you realize you have done an error in the arrangement of the columns and rows.