How to transpose data in excel

Sometimes we receive data which is running horizontally for given year. It is difficult to interpreted data and linking in another workbook/worksheet becomes tedious task. But there is cool feature in Excel to transpose that data. Here are the steps to do it.


1. Select and copy the data to transpose (keyboard shortcut to copy [Ctrl + c] )

2. Then select a destination cell. ( I selected cell A11)

3. Then goto Edit -> Paste Special and check Transpose ( keyboard shortcut [Alt + E + S + E] )

4 .Click Ok.

Thats it.


Note: The above keyboard shortcuts I mentioned works for both Excel 2003 and Excel 2007.