MS Excel - Transpose Rows And Columns

If you want to flip the rows and columns in a table, follow the steps.

1. Select a table that you want to transpose. 
2. Press Ctrl + C to copy the table.
3. Move the cursor to a cell in a blank part of your worksheet.
4. On the Home tab, click the down arrow below the Paste icon.
5. Click the Transpose. 
6. Output looks like