Transpose column into row in Excel 2007, 2010


Are you stuck at changing row into column or vice -versa? Any row can be easily transposed as column and column as row in Microsoft Office Excel (2007, 2010) application. This is possible by using ‘transpose’ option under ‘paste special’ option in Microsoft Excel.

Convert to transpose column into row

1. Open a MS Excel document containing a particular column.

2. Now right-click and copy to select all the cells you want to convert into rows.

3. Now the area where you want to create rows, right-click and select Paste Special.

4. Now check the box in front of Transpose and hit OK.

Here is how you can convert a selected column into Row and the same can be done for converting rows into columns in MS Excel 2007 or 2010.



  1. I’m trying to transpose a column of formulas drawing data from elsewhere but when I hit trnaspose paste the formulas all change. The first formula should be from a cell C5 but changes to C7 and the remainder of the cells change to D7, E 7 etc. What am i doing wrong?

  2. Hello,
    I’m using Excel 2010 and I cannot find the ‘transpose’ option within the paste special clipboard. I’m trying to copy a column of data into a single row. Please advise.

    • The transpose icon in the Excel 2010 paste special options looks like Tetris blocks… one will be horizontal and the other vertical

  3. Excellent post! EXCEPT IT DOESN’T WORK for me. I have a document with 13 columns (with labels at the top and 2046 rows (with labels in the first row). No matter how I try, I always get an error message about the copy and paste areas not being the same size or shape. I have tried every possible combination of clicking on the whole column or just the relevant rows; clicking on the 13 rows and 2046 columns that the new data should fit into, etc. I can make it work when I take just a little chunk of stuff, but when I do the same thing with the whole thing, it doesn’t work.

    I am desperate to get this figured out so I can convert this data (it’s a mailing list) into a database format to make it more reliable for long-term usage by many different people.

  4. Excellent post! Short and easy to understand. Regards!

Add a Comment