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

How to Share a Folder in Windows 10 (3 Methods)

Introduction This guide demos how to share folder in windows 10. It covers 3 methods. Options...

How to Map Network Drive in Windows 10 (5 Methods)

Introduction This guide demos 5 methods to Map Network Drive in Windows 10. Options to...
How to Install Windows 10 1909 Preview Build

How to Install Windows 10 19H2 Preview Build

Introduction If you are a member of Windows 10 Insider Program you can install Windows 10 19H2 Preview Build....

How to Sign in to Windows 10 with a Microsoft Account

Introduction When you installed Windows 10 you may have created and signed in with a local account. You can...
Disable IPv6 in Windows 10

How to Disable IPv6 in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to disable IPv6 in Windows 10: Disable IPv6 from...

Advertisement

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

Advertisement

BEST OF ITECHGUIDES

How to Set Homepage in Google Chrome (Settings or Group Policy)

Introduction You can set homepage in Chrome (Google Chrome) directly from Settings. This method is suitable for individual or...
server 2016 not downloading updates from wsus

Fix for Server 2016 not Downloading Updates from WSUS

Introduction If you experience Server 2016 not downloading updates from WSUS, it is likely caused by a known bug....
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...
active directory interview questions

35 Active Directory Interview Questions and Answers

I have compiled 35 Active Directory interview questions and answers. Where necessary, I have also provided additional information to help you understand...
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...

RECENT POSTS

How to Enable Hyper-V in Windows 10 (3 Methods)

How to Enable Hyper-V in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to enable Hyper-V in Windows 10. To install Hyper-V...
RSAT Tools in Windows 10 Explained: Plus How to Install RSAT

RSAT Tools in Windows 10 Explained: Plus How to Install RSAT

Introduction Starting from October 2018 (1809) update, RSAT Tools became part of Windows 10. From this version of Windows...

How to Enable RSAT for Active Directory in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to enable Active Directory in Windows 10. It is not exactly enabling "Active...
How to Install Windows 10 1909 Preview Build

How to Install Windows 10 1909 (19H2) Preview Build

Introduction Windows 10 1909 Preview is available for Windows Insiders. Made available early September, 2019 you have to be...
How to Install RSAT in Windows 10 (3 Methods)

How to Install RSAT in Windows 10 (3 Methods)

Introduction This guide demos how to Install RSAT in Windows 10. Starting with Windows 10...

How to Share a Folder in Windows 10 (3 Methods)

Introduction This guide demos how to share folder in windows 10. It covers 3 methods. Options...
Configure Map Network Drive with Group Policy

Map Network Drive in Windows 10 with Group Policy

Introduction This guide demos how to map network drive with group policy. This guide is...

How to Map Network Drive in Windows 10 (5 Methods)

Introduction This guide demos 5 methods to Map Network Drive in Windows 10. Options to...
How to Download Windows 10 ISO with Media Creation Tool

How to Download Windows 10 ISO with Media Creation Tool

Introduction This guide demos the steps to download Windows 10 ISO. You can download Windows 10 ISO with Media...

How to Install Windows 10 from Network Boot (Via WDS Server)

Introduction This guide demos how to install Windows 10 from network boot. The steps discussed in...

Advertisement

MUST READ

No Root File System is Defined

‘No Root File System is Defined’ When Installing Ubuntu [Fixed]

Introduction You are reading this because you probably received the error message "No Root File System is Defined" during...
powershell add ad computers to array

How to Add AD Computers to a Powershell Array

Introduction There is one way to add AD Computers to a PowerShell array. A PowerShell array is a data...
windows 10 keeps going to sleep

What to Do If Windows 10 Keeps Going to Sleep

Introduction It can be frustrating if suddenly your Windows 10 keeps going to sleep. You have to log back...
windows 10 lock screen timeout

How to Change Screen Time Out Setting in Windows 10

Introduction There are two easy ways to change Windows 10 lock screen timeout settings: Desktop...
windows server 2016 recovery mode

2 Ways to Boot Windows Server 2016 to Recovery Mode

Introduction You can boot Windows Server 2016 Recovery Mode in two ways: Without installation media...

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