Transposing Rows and Columns in Excel

By June 3, 2019 Tech Tip

What’s transposing in Excel? “To transpose” means to make items change places with each other, or to flip a grid or table such that columns become rows and rows become columns.

This may be a little hard to grasp, but it’s something that you may frequently want to do in Excel: How do you take values in a row and flip them so that those values are stacked in a column? (Or vice versa.) The answer is transposing them. This is how.

Transposing in Excel

Say you have data in rows, like this, and you want these names to be moved into a column.

Tranposing Rows & Columns in Excel

  1. Select and highlight all the values you want to transpose.
  2. Copy the values (Ctrl + C).
  3. Select the cell where you want to insert the values as a column.
  4. Right click and from the menu choose Paste Options > Transpose. If you do not see the Transpose icon, choose Paste Special… > Transpose.Tranposing Rows & Columns in Excel

Then your values will be pasted, but into a column, rather than the original row.

Tranposing Rows & Columns in Excel

You can do the same thing to move a column to a row, or even to flip an entire table, as in this example, where the Y axis becomes the X axis.

Tranposing Rows & Columns in Excel

Transposing may be a little hard to wrap your head around at first (how is the data flipping?), but it can be very helpful in manipulating data once you get the hang of it.


Recent Posts / View All Posts

Remember software and hardware updates are essential to cyber security

Upgrade from Windows 7 to Remain Secure and Stable

| Announcements, Security | No Comments
It’s still coming whether we like it or not: Windows 7 End of Life. If your organization is still running Windows 7, what can you expect? Is this truly the end of Windows 7, and should you upgrade? The answer, realistically, is yes. It’s a smart move to upgrade now, for security and stability. Mainstream support for Windows 7 ended in 2015. Extended support ends on January 14, 2020. Windows 7 is now end-of-life. It will not be supported, nor will it receive regular patches and security updates. What's the risk of not upgrading? Failing to upgrade to supported software,…
Dictate in Office 365

Dictate Instead of Typing in Office 365 Apps

| Office 365, Tech Tip | No Comments
Did you know that in many Office 365 applications you can dictate text instead of typing it? You may find this useful, especially if you need to respond to an email message and your hands aren’t free, or if you want to brainstorm out loud and capture your thoughts without taking notes by hand. First you should check if you have a working microphone. If you're using Windows 10, you can use the Voice Recorder app to do a test. Open this program and record a small snippet of audio. Play it back in order to see if your microphone…
Microsoft 365 Cloud-Based Apps and Security

What Is Microsoft 365 vs. Office 365?

| Cloud Solutions, Office 365, Security | No Comments
You may have started to hear about Microsoft 365. Is it the same as the similarly named “Office 365”? The two are different, and here we’ll explain the difference and what Microsoft 365 Business can offer your organization. First of all, Microsoft 365 is not the same thing as Office 365. Office 365 is a cloud-based suite of productivity apps, such as Word, PowerPoint, Excel, and Outlook. It’s the modern, cloud-based version of the Microsoft Office suite of products you’re probably familiar with already. Microsoft 365 Business is a bundle of services that include the apps and productivity tools of…