+8Hi,
I have one column in my excel file that show tha values like below:
VARIEDADE
ABB4, ABB2, ABB4, ABB5
ABB4
ABB2, ABB5
ABB2, ABB2
ABB4, ABB4, ABB4, ABB4
The two last lines have the same value separated by comma. I would like to simplify like below:
ABB2
ABB4
How Can I do this?
Thank´s
Best answer by dustin
I would break the values out into a list using AttributeSplitter, remove the duplicates via ListDuplicateRemover, then concatenate the unique values back into the original attribute using ListConcatenator.
+30I would break the values out into a list using AttributeSplitter, remove the duplicates via ListDuplicateRemover, then concatenate the unique values back into the original attribute using ListConcatenator.
+8I would break the values out into a list using AttributeSplitter, remove the duplicates via ListDuplicateRemover, then concatenate the unique values back into the original attribute using ListConcatenator.
Thank´s very good!!
You can easily remove duplicate values from your comma-separated list using an online tool. In Excel, you can also use:
=TEXTJOIN(", ", TRUE, UNIQUE(TRIM(TEXTSPLIT(A1, ","))))
This formula splits the values, removes duplicates, and joins them back. Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
