How to convert columns table to rows in Microsoft Excel 2007

When you process your data in Microsoft Excel 2007, sometime you need to convert your columns table to rows or otherwise. Usually, the beginner who does not know how to convert it, they will move one by one table or create it manually. Absolutely, this is needed more time.

There is easy way to convert your column table or otherwise. You can copy your data and use “paste special”.  Read the instruction below to get the details.

How to convert columns table to rows in Microsoft Excel 2007

1. Block your table that you will change


2. Copy the table that you have blocked.




3. Click “Paste special”




4. Check “Transpose”




5. Last, click “OK”