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.
- Select and highlight all the values you want to transpose.
- Copy the values (Ctrl + C).
- Select the cell where you want to insert the values as a column.
- Right click and from the menu choose Paste Options > Transpose. If you do not see the Transpose icon, choose Paste Special… > Transpose.
Then your values will be pasted, but into a column, rather than the original row.
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.
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.