How To Convert Columns To Rows In Excel 2 Easy Methods

How to Convert Columns to Rows in Excel?

There are two methods of doing this:

Let us take the below example to understand this process.

We have the sales data location-wise.

This data is very useful for us, but we want to see this data in vertical order so that it will be easy to compare.

Let us take another example to understand this process.

We must select the whole data and go to the “HOME” tab. Then, we must click on the “Copy” option under the “Clipboard” section. You may refer to the below screenshot. Else, press “CTRL +C” keys to copy the data. Then, we must click on any blank cell where we want to see the data. Next, we must click on the “Paste” option under the “Clipboard” section. You may refer to the below screenshot. As a result, this will open a “Paste” dialog box. Then, choose the option “Transpose,” as shown below. Consequently, it will convert the columns to rows and display the data as we want. The result is shown below:Now, we can put the filter and see the data differently.

The result is shown below:Now, we can put the filter and see the data differently.

We have some student score data subject-wise.

Now, we have to convert this data from columns to rows.

Follow the below steps for doing this:

Step 1: We must first select the whole data and right-click. As a result, it will open a list of items. Now, we must click on the “Copy” option from the list. You may refer to the below screenshot.
Step 2: We need to click on any blank cell where we want to paste this data.Step 3: Again, right-click and select Paste Special optionPaste Special OptionPaste special in Excel allows you to paste partial aspects of the data copied. There are several ways to paste special in Excel, including right-clicking on the target cell and selecting paste special, or using a shortcut such as CTRL+ALT+V or ALT+E+S.read more.
Step 4: Again, it will open a “Paste Special” dialog box.Step 5: Then, click on the “Transpose option,” as shown in the below screenshot.Step 6: Lastly, we must click on the “OK” button.

Now our data is converted from columns to rows. The final result is shown below:

In other ways, when we move our cursor or mouse on “Paste Special” option, it will again open a list of options as shown below:

Converting columns to rows or vice-versa both methods also work when we want to convert a single column to a row or vice-versa.This option is very handy and saves a lot of time while working.