Effect:
Keep the uniqueness of ABC's three column values, add a line identifier, and use the above method to group ABC's three columns into one column, as shown below:
1, ABC marked in yellow is a duplicate value, and the first behavior identifier is added;
2. Copy and paste to another? Within the table, it is classified into columns and has the function of deleting duplicates;
3, according to the identifier, the column value is reset, the effect is as follows:
I hope to achieve the effect you want.
I wonder if you can operate SQL? Database, if possible, import the data from excel into the database, and use SQL? Statement? Very different? It is also possible. Delete multiple columns with excel. I wonder if there is any other way for the time being. . Look at other people's ways. .