How to Switch Data from Rows to Columns (or Vice Versa) in Excel


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.

Click here to watch this video on YouTube.

Get the best tips and tricks in your inbox daily