1. In the following table, I want to put the same name information together in the name column.
2. Select the data in the name column, and the selected mark is the thick black line in the table. Then, on the Start tab, select Sort in turn.
3. Click Custom Sort.
4. Select Column A in the Primary Key column, and then click OK.
5, as shown in the figure, get the same name arrangement.
Join a club and study together.
Want to know more about excel, recommend consulting Secco workplace. Taking production research and curriculum research as the core competitiveness of the workplace, Secco has comprehensively applied new technologies such as artificial intelligence, big data and cloud computing, and innovatively developed the teaching mode of "live broadcast by famous teachers +AI guidance+students' practical exercises+teaching assistants' answering questions". Based on the concept of game flow, we will cooperate with industry experts and consultants to polish the course content, create an immersive learning experience and professional knowledge system for students, and help students truly master the hard skills in the workplace.