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

IT Leadership | Shared CIO

You Need IT Leadership

| Consulting, Leadership | No Comments
Missouri is just beginning to emerge from its stay-at-home order in response to the pandemic threat. Who ever imagined that pandemic planning policies would become a reality? What was once regarded as a threat with low probability of occurrence will likely become a much higher probability as we navigate through the coming years. The realization of this threat has certainly changed the way we view ourselves and the world around us. It has sensitized us to our newfound vulnerability. This month, I am writing to you from the Joplin, MO office of OXEN Technology. Considering our present circumstances, our physical…
Tech Tip Background

Office 365 Tip: Create a file request in OneDrive

| Office 365, Tech Tip | No Comments
If you need to obtain files from various people, you can use OneDrive to create a file request that allows others to upload documents directly to a folder you specify. This gives people a quick way to transfer files to you without giving them view or edit permissions to your OneDrive folder. Here’s how! Note: This feature is not available in Office 365 Government. For file requests to work, your Office 365 administrator must enable Anyone links in OneDrive. Requesting Files Using OneDrive Online, select the folder where you want others to upload their files. Click Request files on the…
Virtual Private Network

What is a VPN and do you need one to work from home?

| Security | No Comments
Since businesses started shifting to remote work due to COVID-19, OXEN has seen a sizeable uptick in requests for purchasing and implementing VPNs for at-home workers. You’ve probably seen that a Virtual Private Network (VPN) connection is often recommended for securely working from home while accessing company resources. So what’s a VPN for in this context, and do you need one? If you’re a business manager, do you need a VPN connection for every employee who’s now working from home? Read on for our tips. What Is a Virtual Private Network? VPN stands for “Virtual Private Network”. It creates a…