Use Word and Excel to implement table row and column transpose

When you use Word to make a table, you often encounter situations where you can transpose rows and columns of a table. How do you do this if you transpose table 1 's three rows four columns into a four row three column style (table two)?

Results	Mathematical	English	History
Tom	89	60	88
John doe	68	76	77

Table I

Results	Tom	John doe
Mathematical	89	68
English	60	76
History	88	77

Table II

1, create tables like table one, and then select the entire table, right click, in the pop-up drop-down menu, choose Copy.

2, open Excel, perform the Edit menu, select Paste, select text, click OK.

3, select the table in Excel, right-click, select Copy in the pop-up Drop-down menu, click in any cell, select Paste on the Edit menu, click "√" in the pop-up menu (as shown below), and clicking "OK" (below).

Transpose

4. Select the table that has been transferred, right-click, select Format Cells in the Drop-down menu, select All borders, click OK, and then copy the form.

5, click "Paste" in Word.

Now you can see that the table has been successfully transferred and can be edited arbitrarily.