How to merge similar items in excel

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

Quick Key [Ctrl G] to call out the positioning pop-up window as shown below, select "Null" and then click "Position"

Next click the menu: Start-Merge and Center, you will see the following The picture looks like this

This step is similar to steps 2 and 3. We select all tables and click on the menu: Data-Classification Summary. This time, instead of clicking "OK", click "Delete All"

What you see is as follows. We select the blank column and click on the menu: Start-Select Blank Column-point format brush

# and then select the "target column", here we are the director. You will find that our goal has been achieved

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!