Excel 2007 convert columns to rows

I am going to share another timesaving tip for Excel. Many time we need to present our data in different way. As a developer I find Excel very convenient to create sample data for my projects and then insert it into the Database. What if we want to re arrange the data which is coming in columns to rows?. Yes, you can easily change data representation row-wise. To do this, copy the data after highlighting it.  After this, right click on the cell where you want to show it.


From the shortcut menu select Paste Special , this will show you a dialog box  similar to below image :


Select  Transpose  and press ok button. You will find you column data is arranged row-wise.


You can follow similar steps to convert row data into column layout. This trick should also work with Excel 2010 version.


Post a Comment