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
Advertisement

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.
Advertisement
  • 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

network discovery keeps turning off server 2016

How to Fix Network Discovery If it Keeps Turning Off in Server 2016

Does network discovery keep turning off in your Windows server 2016? It is likely that one of its dependent services is not...
how to install windows 10 1903 update manually

How to Install Windows 10 1903 Update Manually

Windows 10 1903 Update was released in May, 2019. But some users are not yet offered the update via automatic update. The...
spotify web player not working

Spotify Web Player Not Working [Fixed]

Introduction Spotify Web Player may stop working for you with the following error messages: "Spotify Web Player an Error...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
DHCP Relay agent

DHCP Relay Agent: Configuration in Windows Server 2016

What is a DHCP Relay Agent? A DHCP Relay Agent allows DHCP clients in a different network subnet to...

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...

BEST OF ITECHGUIDES

How to Make a Scatter Plot in Excel

How to Make a Scatter Plot in Excel

Introduction You make a scatter plot in Excel to compare 2 sets of data. Unlike a Line Chart, a...
Amazon best sellers

Amazon Best Sellers: Your Definitive Guide to Find Them

What are Amazon Best Sellers? Amazon Best Sellers are the most popular products on Amazon, based on sales. Amazon...

Powershell If Else Explained: Syntax and Examples

Introduction PowerShell If Else statement runs a command if a specified condition is met. The Else part of PowerShell...
file too large for destination file system

The File is Too Large for the Destination File System [Fixed]

What is the cause of "The File is Too Large for the Destination File System" Error? The "The File...

Powershell For Loop Explained: Syntax and Examples

Introduction "Powershell For Loop" (or Statement) is a construct that is used to run a command in a...

RECENT POSTS

disable cortana windows 10 featured

How to Disable Cortana in Windows 10 (2 Methods)

Introduction Some Windows 10 users may not like Cortana. Solution? Disable Cortana. You are probably reading this because you...
bootrec /fixboot access is denied

How to Fix BootRec /FixBoot Access is Denied Error in Windows 10

Introduction BootRec /FixBoot Access is Denied Error in Windows 10? This error is likely caused by corrupt EFI directory.
Reset Windows 10

How to Reset Windows 10 (2 Methods)

Introduction If your Windows 10 is broken, one available way to fix it is to use Windows 10 reset....
system restore windows 10

How to Enable and Use System Restore in Windows 10

Introduction System restore in windows 10 is a very important tool that is probably ignored by most users. But...
windows has stopped this device code 43

How to Fix Windows Has Stopped this Device Code 43 Error

Introduction Sometimes you may receive "Windows has stopped this device code 43" error. This error is likely to come...
Windows could not automatically detect this network's proxy settings

How to Fix “Windows Could not Automatically Detect this Network’s Proxy Settings”

Introduction You suddenly lose the ability to connect to the internet. Then you run network troubleshooter and it returns...
printer offline

5 Ways to Restore Your Printer Online If Status is Offline

Introduction Is your printer offline? Setting it online is very simple but sometimes it is more than just setting...

How to Fix “BootMgr is Missing” Error in Windows 10

Introduction If you receive Fix "BootMgr is missing" Error in Windows 10, the default response is panic! But you...
windows 10 search featured

How to Fix Windows 10 Search If it Stops Working

Introduction Are you having troubles with Windows 10 search? Apparently, it is a fairly common problem with a number...
oooops, something went wrong. reload

How to Fix “Oooops something went wrong. reload” Spotify Error

Introduction If you receive "Oooops something went wrong. reload" Spotify error, do not panic. The fix is simpler than...

MUST READ

WSUS

WSUS (Windows Server Update Service): Installation and Configuration

What is WSUS Server? WSUS (Windows Server Update Service) is a Microsoft Server role that allows download and installation...
excel document not saved

How to Fix “Document not Saved” Error in Excel

Excel "Document not Saved" Error may be caused by one of the following: Attempting to save a shared...
ForEach-Powershell

PowerShell ForEach: Syntax, Parameters, Examples

What is PowerShell ForEach? PowerShell ForEach (ForEach PowerShell) is a PowerShell construct used in iterating through values in a...
avast vpn

Avast VPN: How to Install, Setup and Stay Safe Online

What is Avast Secureline VPN? Avast VPN is a VPN (Virtual Private Network) software that allows you to...
PowerShell Not Equal

PowerShell Not Equal Operator: Applications, Examples

Introduction PowerShell Not Equal Operator is one of the Comparison Operators. PowerShell Not Equal (-ne) compares two values. If...

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