First, we need to select the first cell A1, and then press the shortcut key "Ctrl A" to select the entire table. Select the entire table and press Ctrl C to copy the table.
The second step is to create a new worksheet, click on cell A1 of this new worksheet, right-click the mouse and select "Paste Special" in "Paste Special" ".
#The third step, after clicking, a new "Paste Special" dialog box will pop up. We select "Transpose" at the bottom. Then click OK.
More related tutorial recommendations:excel tutorial
The above is the detailed content of How to convert a horizontal table into a vertical table in Excel. For more information, please follow other related articles on the PHP Chinese website!