How to Switch Data from Rows to Columns (or Vice Versa) in Excel
November 14, 2016 / / Comments Off on How to Switch Data from Rows to Columns (or Vice Versa) in Excel
< 1 minute read

Here’s a quick trick in Excel that can be really handy if you’ve started to enter some data in a row, but decide that you’d like it in a column instead (or vice versa). Don’t change it manually–use Excel’s Transpose function instead.
Let’s say you have a row of data, and you’d like this data to be vertical in a column instead.
- First, highlight the data you’d like to move, and then copy it by either right-clicking or holding Ctrl + C (Windows) or Command + C (Mac). This doesn’t work if you cut data, so make sure you’re copying, and not cutting.
- Right-click on the cell where you want the newly positioned data to start displaying.
- Head down to Paste Options > click on the Transpose icon.
- As you can see, your data will flip the other way.
If you have a column of data that you’d like to make into a row, the same process applies. Copy the data, right-click on a new cell, and then go to the Transpose icon under the Paste Options.
For Tables:
- If you have a table that includes both horizontal and vertical data organization, copy the data, right-click on a new cell, and select the Transpose icon in the Paste Options.
- As you can see, you get a new table with your data listed in the opposite direction than it was running before.