How remove duplicates words according other column word in a row

[renatopnovaes]

I have this data with the products and their respective groups. However, the same product is part of two groups. In my case I have the product "FANTA GUARANA ZERO 2L 6UN" which is part of the groups "SABORES SA 2L" and "FANTA GUARANA 2L". I wanted the product "FANTA GUARANA ZERO 2L 6UN" to be part of the "SABORES SA 2L" GROUP.  I Need distinct items for create a key.

It's possible?

[renatopnovaes]

@PC2790  Thank you my friend!

[PC2790 · Accepted solution]

If I understand your requirement correctly, you can concatenate the two columns and then remove duplicates based on that column.

Or you can create an index column based on your required column and do the further transformations accordingly

I hope one of these will work for you.