WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Convert Columns to Rows in Excel

Convert Columns to Rows in Excel

How to Convert Columns to Rows in Excel?

There are two methods of doing this:

  1. Excel Ribbon Method
  2. Mouse Method

Let’s take the below example to understand this process

You can download this Convert Columns to Rows Excel Template here – Convert Columns to Rows Excel Template

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

We have the sales data location wise.

Convert Columns To Rows Example 1

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 the below steps for doing this:

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

Convert Columns To Rows Example 1-1

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

Convert Columns To Rows Example 1-2

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

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

The result is shown below:

Convert Columns To Rows Example 1-4

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.

Example 2

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Follow the below steps for doing this:

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

Example 2-1

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

Example 2-2

  • Step 4: It will again open a paste special dialogue box.
  • Step 5: Click on the Transpose option, as shown in the below screenshot.
  • Step 6: Click on the OK button.

Example 2-3

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

Example 2-4

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:

Example 2-5

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 a 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 a downloadable excel template. You may learn more about excel from the following articles –

  • Count Rows in Excel
  • How to Convert Excel to CSV?
  • Convert Text to Columns in Excel
  • Row Limit in Excel
  • MMULT in Excel
94 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Convert Columns to Rows Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More