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

Managed Services

Top 5 Benefits of Managed IT Services

| Managed Services | No Comments
There are many benefits to outsourcing your IT with managed services. Here are our picks for the top five – though certainly this isn’t a comprehensive list. #1: Operational Expenses and Controlling IT Costs If your environment is ready for managed services, then outsourcing your IT requires only a small initial investment. Then all your IT needs are rolled into an ongoing predictable monthly payment. This means managed services is primarily an operational expense, and far easier to predict and budget for. Controlled and predictable spending on your IT? Always a good idea. On top of making this switch away…
Windows 7 End of Life

Are you prepared for the end of Windows 7?

| Announcements | No Comments
Windows 7 and Windows Server 2008 are popular and well-loved — and they're completely unsupported after January 2020. Have you prepared to upgrade yet? When Windows 7 reaches end of life and end of support in 6 months, it will no longer be a secure, compliant operating system. Microsoft will no longer releases updates or security patches. If you continue using it, you will be putting your data at risk. Hackers love to target unsupported applications and take advantage of vulnerabilities in legacy software. You don't want to be in the cross-hairs. Consider too that other services and manufacturers will…

Transposing Rows and Columns in Excel

| Tech Tip | No Comments
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…