How to switch data from rows to columns in Excel

October 21, 2021
129 Views 0

Graphic skills

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