How to Transpose in MS Excell
If You want to change the order of tabular data in MS Excel from vertical to Horizontal or Horizontal to vertical then follow the steps.
Step 1: Copy The Tabular data in excel sheet.
Step 2: Select Paste Special where ever u want to paste in same sheet or another sheet.
Step 3: Enable the ‘Transpose’ option from Paste Special Dialog Box and press ok.
Step 4. Finish. u can check the following video for demonstration.