+9Hi,
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.
+36I 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.
+9I 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!
