How to convert column in rows

How to Convert a Column to a Row in Excel

Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row, or vise-versa.  Here’s a simple trick to convert any row or set of rows into a column, or vise-versa, in Excel.In case of Bulk data you want to convert in rows from column you don’t need to reenter data in rows and don’t need to waste your time.

Please Note: This is tested in Excel 2003, 2007, and 2010.  Here we took screenshots from Excel 2010 x64, but it works the same on the other versions.

Convert a Row to a Column

Here’s Sample data in Excel:

How to convert column in rows

If you want to change these two data columns into rows.  Select all the cells you wish to convert, right-click, and select copy (or simply press Ctrl+C):

Microsoft excel

Now, you should do right-click in the cell where you want to put the data in rows, and select “Paste Special Option from that drop down manue.”

Convert column in rows

Now a Pop up Window will be open.Check the box at the bottom that says “Transpose”, and then click OK.

Microsoft excel 2007

Now your Sample data will be converted in rows from columns! 

Microsoft excel 2003

This works the exact same for converting rows into columns.  Here’s some data in rows:


After copying and pasting special with Transpose selected, here’s the data in columns! This way you can save your time.

Microsoft excel

This is a great way to get your data organized just like you want in Excel.

4 thoughts on “How to Convert a Column to a Row in Excel”

  1. Thank you a lot for providing individuals with a very brilliant possiblity to check tips from this website. It is always very beneficial and as well , full of amusement for me and my office colleagues to visit your website at the very least three times in one week to find out the latest stuff you will have. Of course, I am also at all times motivated with all the spectacular ideas served by you. Certain 1 ideas in this posting are essentially the most impressive we have had.

  2. Thank you for all your valuable hard work on this site. My daughter really likes conducting investigations and it’s really easy to understand why. Almost all hear all regarding the dynamic form you present great items by means of the web blog and inspire contribution from some others on the concern plus our favorite child is without question understanding a whole lot. Enjoy the remaining portion of the year. You are always carrying out a pretty cool job.

  3. Thank you so much for giving everyone an extremely breathtaking possiblity to read from this blog. It is usually so terrific plus full of fun for me personally and my office friends to visit your website at the very least thrice in one week to learn the new tips you have. Of course, I am just usually motivated with the striking creative ideas you give. Some 4 facts on this page are unquestionably the finest we have all ever had.

  4. A lot of thanks for all of the labor on this website. Kim take interest in working on research and it’s obvious why. I know all about the dynamic mode you provide invaluable tips and tricks via the web blog and as well welcome response from others on that point so our own child is without a doubt learning a whole lot. Enjoy the remaining portion of the new year. You have been carrying out a useful job.

Leave a Reply

Your email address will not be published.