Transpose Excel Column to Row or Row to Column

If you have a worksheet & you need to rearrange the column into row or vice versa. The flip flop between the rows & column seems time consuming & tiring process but in real it is not. As the Microsoft Excel provide you the automated transpose option in its tools bar which enable you to rearrange your column into row or row into column with its transpose feature in Paste Special option