How to Move Columns to Rows and Rows to Columns in Excel

-

|

Introduction

If you receive some Excel data in columns, you can easily move the columns to rows in Excel with paste special, transpose. This quick guide shows 2 easy ways to transpose data in Excel.

How to Move Columns to Rows in Excel With Paste Special (Right-click Method)

The Excel worksheet below shows some data in a column.

how to move columns in excel example 1

In this first example, I will demonstrate how to move columns to rows using Paste Special, right-click method.

To move the data from columns to rows, follow the steps below:

  • Select all the data you wish to move from columns to rows in Excel.
How to Move Columns to Rows in Excel With Paste Special (Right-click Method) - select all data
  • Next, copy the data. You can use Ctrl + C or right-click and copy.
How to Move Columns to Rows in Excel With Paste Special (Right-click Method) - copy data
  • Right-click the cell you want to move the data to. Then select Paste Special.
  • When Paste Special option opens, check the box beside Transpose. Then click OK.
Data moved from columns to rows.
You can delete the original data in columns and leave the data in rows.
You can also access Paste Special from Excel Home tab.

To access Paste Special from Home tab, follow the steps below:

  • Copy the data. Then click the Home tab. Click the drop-down beneath Paste.

How to Move Columns to Rows in Excel With Paste Special (Keyboard Shortcut Method)

Another way to Paste Special is to use the keyboard shortcuts, Ctrl+Alt+V, or Alt+E+S.

Below are the steps to Move Columns to Rows in Excel with this method.

  • Select all the data you want to move from columns to rows in Excel.
How to Move Columns to Rows in Excel With Paste Special (Ctrl+Alt+V Method) - select all data
  • Next, copy the data. You can use Ctrl + C or right-click and copy.
How to Move Columns to Rows in Excel With Paste Special (Keyboard Shortcut Method) - copy the data. You can use Ctrl + C or right-click and copy.
  • To paste special using keyboard shortcut, click the sell you want to move the columns to rows to. Then, in your keyboard select either Ctrl+Alt+V, or Alt+E+S.
  • The data will be moved from columns to rows.

How to Move Rows to Columns in Excel

The steps to move data in rows to columns is exactly the same for moving data from columns to rows. The only difference is that you now copy the cells that are in a row. Then paste special. Finally, check the transpose box and click OK.

Conclusion

If you ever receive data in columns and want to move them to rows, you can see how easy it is to do this.

Have questions or comments regarding how to move columns to rows in Excel? Use the “Leave a Reply” form at the end of the page.

Alternatively, you can share your experience with other readers.

Other Helpful Guides

Additional Resources and References

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ADVERTISEMENTS

FEATURED POSTS

Best Christian Movies on Netflix

The 10 Best Christian Movies on Netflix

This Itechguide reviews the 10 best christian movies on Netflix. The movies are listed in reverse order – with the 10th movie...
How to Change Orientation in Google Docs

How to Change Orientation in Google Docs

This Itechguide teaches you how to change orientation in Google Docs. The guide covers steps to change orientation in Google Docs from...
How to Delete Google Photos

How to Delete Google Photos

This Itechguide teaches you how to delete Google Photos. The guide offers steps to delete Google Photos from the Google Photos App...
How to Install Windows 10 1909 Update Manually

How to Install Windows 10 1909 Update Manually

This Itechguide teaches you how to install Windows 10 1909 update manually. Windows 10 1909 (otherwise known as Windows 10 November update)...
How to Create a Poll on Facebook

How to Create a Poll on Facebook

This Itechguide teaches you how to create a poll on Facebook. You can create a poll on Facebook from a Facebook page...

AMAZON DEALS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

ADVERTISEMENTS

BEST OF ITECHGUIDES

How to Insert Multiple Rows in Google Sheets

How to Insert Multiple Rows in Google Sheets

This guide demos how to insert multiple rows in Google Sheets from a PC - Sheets.Google.com Here are the...
preparing to configure windows stuck

How to Fix Windows 10 Stuck at “Preparing To Configure Windows..”

Introduction Here is how this plays out: Windows update notifies you of available updates. You download and install them....
How to Uninstall Dropbox

How to Uninstall Dropbox (from Windows 10, Android and iPhone)

This Itechguide teaches you how to uninstall Dropbox. The guide offers steps to uninstall Dropbox from Windows 10, an Android phone and...
what is active directory

What is Active Directory (Top 50 AD Questions Answered)

Introduction This article answers the question - What is Active Directory and 49 other most widely asked AD questions....
How to Burn Windows Server 2019 ISO to USB

How to Burn Windows Server 2019 ISO to USB

Introduction This guide demos how to burn ISO to USB. Specifically, the guide demos how to burn Windows Server...

RECENT POSTS

How to Change Facebook Page Name

How to Change Facebook Page Name

This Itechguide teaches you how to change Facebook page name. The guide covers steps to change Facebook page name from a PC...
How to Change YouTube Channel Name

How to Change YouTube Channel Name

This Itechguide teaches you how to change YouTube channel name. The guide covers steps to change YouTube channel name from a PC.
How to Bold Text on Facebook Post

How to Bold Text on Facebook Post

This Itechguide teaches you how to bold text on Facebook post. The guide covers steps to bold text on Facebook post from...
Best Crime Documentaries on Netflix

The 10 Best Crime Documentaries on Netflix

This Itechguide reviews the 10 best crime documentaries on Netflix. The documentaries are listed in reverse order – with the 10th documentary...
Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....

AMAZON DEALS

MUST READ

Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....
concatenate excel

Concatenate in Excel: How to Concatenate Columns and Strings

What is Concatenate in Excel? Concatenate in Excel is joining two strings into one continuous string. You can join...
How to Uninstall Dropbox

How to Uninstall Dropbox (from Windows 10, Android and iPhone)

This Itechguide teaches you how to uninstall Dropbox. The guide offers steps to uninstall Dropbox from Windows 10, an Android phone and...
Windows defender blocked by Group Policy

Windows Defender Blocked by Group Policy [Fixed]

Introduction If you receive the error message Windows Defender is blocked by group policy, your computer may have been...
How to Turn off Comments on Facebook Post

How to Turn off Comments on Facebook Post

This Itechguide teaches you how to turn off comments on Facebook post. The guide offers steps to turn off comments on Facebook...

AMAZON DEALS

By using this website you agree to accept our Privacy Policy and Terms & Conditions