|

FEATURED POSTS

How to Change Outlook Password in 3 Different Ways

How to Change Outlook Password in 2 Easy Steps

Introduction Before you change your Outlook Password you have to first change it with your email provider. The reason...
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...
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...

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...
PowerShell vs CMD

Powershell vs CMD: Differences and Similarities Compared

Introduction This short guide compares PowerShell vs CMD (Windows command prompt). I will cover the history and nature of...
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

windows deployment services

Windows Deployment Services (WDS): Installation & Configuration

What is Windows Deployment Services Server? Windows Deployment Services (WDS) is a server role that provides a simplified and...
DISM Host Servicing Process (DismHost.exe)

Dism Host Servicing Process (DismHost.exe), a Malware?

Introduction There are conflicting information about Dism Host Servicing Process (DismHost.exe). Some say it is a genuine Windows process,...
how to move columns in excel

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...
How to get help in Windows 10

How to Get Help in Windows 10 in 5 Easy Ways

Introduction This "How to Get Help in Windows 10" guide discusses 5 easy ways you can find help while...
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...

RECENT POSTS

how to merge cells in excel

How to Merge Cells in Excel in 2 Easy Ways

Introduction You can merge two Cells in Excel using CONCATENATE function or the “&” (ampersand) operator. Though Excel has...
How to Make a Pivot Table in Google Sheets

How to Make a Pivot Table in Google Sheets

Introduction You can make a Pivot Table in Google Sheets to simplify analysis of complex data. A Pivot Table...
how to make Pivot Table

How to Make a Pivot Table in Excel

Introduction A Pivot Table allows you to analyze, summarize and calculate large data to help find relationships. With a...
RAID 3 (Redundant Array of Independent Disks) Explained

RAID 3 (Redundant Array of Independent Disks) Explained

What is RAID 3? RAID 3 is a RAID implementation that uses striping with a dedicated parity disk....
RAID 5 vs RAID 6

RAID 5 vs RAID 6: Differences, Benefits and Disadvantages

What is RAID 5 vs RAID 6? RAID 5 and RAID 6 uses striping with distributed parity technique. However,...
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 Add in Excel (Excel Sum) with Examples

Introduction There are different ways to add numbers in Excel. You could simply select the cells containing the data....
Excel Count

Excel Count: How to Count in Excel With Examples

Introduction Excel COUNT Function is used for counting items in a worksheet. Excel COUNT also has the conditional function,...
powershell.exe -command

Powershell.exe Command: Syntax, Parameters and Examples

Introduction You may be wondering why write on Powershell.exe Command. Are there special commands for Powershell.exe? Yes! When you...
how to move columns in excel

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

MUST READ

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

ClearScore Can Help Improve Your Credit Score for FREE (Here is How)

What is ClearScore and Who is ClearScore? ClearScore (Some call it Clear Score!) is a London-based financial services company...

How to Add in Excel (Excel Sum) with Examples

Introduction There are different ways to add numbers in Excel. You could simply select the cells containing the data....
Outlook 365: Subscription, Installation and Set Up

Outlook 365: Subscription, Installation and Set Up

If you are reading this you are probably one of the many people asking a lot of question about outlook 365 -...
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...

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

YOU MAY ALSO LIKE:

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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