1. Open the table to be split.

2. select the data to be separated, directly select the whole column, and click data-> separate again.

3. click "fixed width" > "next" in the pop-up interface

4. Click on columns 10 and 20 to indicate that the data will be classified according to the number of 10, and then click "Next Column".

5. Click "Finish"

6. The effect is as follows ~