How to divide one column into multiple columns in Excel

There is a list here, and the people in it should be divided into three groups.

Enter A2 in the column that needs to be grouped, which is the cell number of the name column, and then drop down to fill in. Do the same in other columns until the columns are divided. .

Select these sequence cells, CTRL H to open find and replace, search for A, replace with =A, and finally click Replace All.

Then all lists will be automatically grouped.

The above is the detailed content of How to divide one column into multiple columns in Excel. For more information, please follow other related articles on the PHP Chinese website!