How to switch data from rows to columns in Excel

October 21, 2021
575 Views 0

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.How to switch data from rows to columns in Excel.gif


WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc

Was this helpful?