How to switch data from rows to columns in Excel
1. Select the table for operation, and right-click to copy it (Shortcut key: Ctrl + C).
2. Right-click on the cell for the new table → click Special Paste → click Transpose.
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.