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

Basic math in Excel: Addition, subtraction, multiplication, and division

Basic math in Excel: Addition, subtraction, multiplication, and division

| Tech Tip | No Comments
Are you new to Excel, and not sure where to start with formulas and operations? Many spreadsheets use basic math: adding and subtracting numbers or multiplying and dividing. Understanding these math formulas will help you graduate to more complex equations to manipulate your Excel data. How does basic math work in Excel? Excel uses formulas or functions to manipulate data. A function takes an input, which is the content of cells plus some operating symbols that say what to do with the data. You can input a single cell into a function or a range of multiple cells. For addition,…
Countdown to end of support for Microsoft products in 2020

Keep Your Tech Relevant: Are You Prepared for Microsoft End of Support Deadlines?

| Announcements, Office 365, Security | No Comments
There are multiple Microsoft products reaching end of support in 2020. These versions are being retired and will no longer have technical support. We’ve previously talked about the end of support for the Windows 7 operating system and Windows Server 2008 on January 14, 2020. However, other products are also reaching end of support in 2020. On January 31, 2020, Internet Explorer 10 will be retired. If you're already upgrading to Windows 10 or using Microsoft Edge as your web browser, then you've taken the next step to upgrade from IE 10. Later, in October 2020, Microsoft Office 2010 is…
Merry Christmas from OXEN

Merry Christmas from the OXEN Team!

| Holiday | No Comments
Merry Christmas and Happy New Year from the Team at OXEN Technology!   OXEN Technology is closed December 24th and December 25th for Christmas and January 1st for New Year's Day.