Home >Software Tutorial >Office Software >How to divide one column into multiple columns in Excel

How to divide one column into multiple columns in Excel

WBOY
WBOYforward
2024-04-17 13:00:02939browse

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

How to divide one column into multiple columns in Excel

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. .

How to divide one column into multiple columns in Excel

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

How to divide one column into multiple columns in Excel

Then all lists will be automatically grouped.

How to divide one column into multiple columns in Excel

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete