Skip to content

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

< 1 minute read

Excel Green1

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.

Sign up for our newsletter