How to Convert Excel 2010 vertical cells to horizontal

If you have entered data into an Excel sheet only to realize it would be better as a row rather than a column, or vice versa, then knowing how to flip the data is a valuable skill.


Step # 1 – Copying the Data

First off, load the sheet that has the data you want to flip. Here we have a small table about the price of some items. We want flip this so the price data is in a row, not a column. First highlight the table, right click on it and choose “Copy”.

Copying the data

Step # 2 – Using the Paste Special Window

Now that the data is in the clip board, click where you want the new table to appear. Here we are placing it just right of the original table. Right click and navigate to “Paste Special…”, in the menu that appears click on “Paste Special…”. This will open a new window, check the “Transpose” check box at the bottom and click “OK”.

Step # 3 – Viewing the Transposed Data
The data will be inserted into the spreadsheet in the new location and as you can see all of the data has been flipped so that the prices are now in rows, rather than columns. This process will also work the other way round.

Data successfully flipped