Method: First click "Classification Summary", select "Count" for "Summary Method", and select the specified column for "Classification Field"; then enter text in the top box of the new column and press the "ctrl g" key to bring up the positioning , select "Null Value"; then select "Merge and Center", cancel "Subtotal"; finally select a blank column, click "Format Painter", and select the target column.
The operating environment of this tutorial: windows7 system, wps office2016 version, Dell G3 computer.
First sort the target column (so that the same data is together), click "B" in the red box to select the target column (our target column here is "Director")
Click on the top menu: Data-Classification Summary
Set the following in the classification summary pop-up window, and finally click OK
We see an extra column next to the director, type a word in the top box, and then select the column, as shown in the picture
Related learning recommendations:
excel tutorial######The above is the detailed content of How to merge similar items in excel. For more information, please follow other related articles on the PHP Chinese website!