How to transpose columns to rows in Excel
1. Select the table area that needs to be transposed.
2. Right-click, and choose Copy in the pop-up shortcut menu, or press Ctrl+C.
3. Select a blank area where we want to paste the transposed table. Right-click, and place the cursor behind the Paste Special option in the pop-up shortcut menu. Finally, click Transpose.
4. Then, we can transpose columns to rows in Excel, and vice versa.