Convert Columns to Rows in Excel

Excel Convert Column to Rows (Table of Contents)

• Convert Columns to Rows in Excel
• How to Convert Columns to Rows in Excel?

Convert Excel Columns to Rows

The data presentation is very important aspects of Excel. Every people looks at the data in his/her own way and try to get the information from it. Let suppose there is a report prepared by someone and it contains very important information. But it doesn’t work for you because of the way you look at the data in different format. Thus, in Excel reorganizing the data is a very important feature and sometimes it’s a pain too when you are working on data arranged in table form.

The simple copy and paste won’t fix this problem. Manually retyping the data is wasting time and tedious task too.

Excel provides an inbuilt feature called TRANSPOSE which converts Columns into Rows and Rows into Columns. This inbuilt capability makes the process easier.

How to Convert Columns to Rows in Excel?

Let us learn to Convert Columns to Rows in Excel by some examples.

There are two methods of doing this:

1. Excel Ribbon Method
2. Mouse Method

Let’s take below example to understand this process

#1 – Using Excel Ribbon – Convert Columns to Rows with copy and paste

We have the sales data location wise.

This data is very useful for us but I want to see this data in vertical order so that it will be easy for the comparison.

Follow below steps for doing this:

• Select whole data and go to the HOME tab.
• Click on Copy option under Clipboard section. Refer below screenshot. Or press key CTRL +C for copying the data.

• Then click on any blank cell where you want to see the data.
• Click on Paste option under the Clipboard section. Refer below screenshot.

• This will open a Paste dialogue box. Choose the option “Transpose” as shown below.

• It will convert the Column to Rows and will show the data as we want.

The result is shown below:

Now we can put the filter and can see the data in different ways.

#2 – Using Mouse – Converting Columns to Rows (Or Vise-Versa)

Let’s take another example to understand this process.

We have some student score data subject wise.

Now we have to convert this data from Columns to Rows.

Follow below Steps for doing this:

• Select the whole data and right click. It will open a list of items. Click on Copy option from the list. Refer below screenshot.

• Then click on any blank cell where you want to paste this data.
• Again Right-Click and click on Paste Special option.

• It will again open a paste special dialogue box.
• Click on Transpose option as shown in below screenshot.
• Click on OK button.

Now your data is converted from Columns to Rows. The final result is shown below:

Or in other ways, when you move your cursor or mouse on Paste Special option, it will again open a list of options as shown below:

Things to Remember

• The process of converting Column to Rows or Vice-Versa, both methods also work when you want to convert a single column to row or vice-versa.
• This option is very handy and saves a lot of time while working.

Recommended Articles

This has been a guide to Convert Columns to Rows in Excel. Here we discuss how to Switch Columns to Rows in Excel using the Ribbon and Mouse Method along with practical examples and downloadable excel template. You may learn more about excel from the following articles –

• Count Rows in Excel
• Delete Row in VBA
• How to Convert Excel to CSV?
• VBA Paste Special in Excel
• Excel Column Lock
• Excel SWITCH Function
• Example of Shortcut in Excel
• How to convert Text to Columns in Excel?
• Delete Rows in Excel
• How to set Row Limit in Excel
• How to Hide a Column in Excel