Getting a word once from multiple words

Hello everyone I was able to use a lookup to get all these instances I could use a join column to give them a comma but tu would return all the same instances. I can’t really explain it but what I need is to bring only one word in a row e.g

row 1 = seed
row 2 = seed, grain fertilizers
row 3 = grains
row 4 = grains, seeds

You could use a UNIQUE ELEMENTS column to remove duplicates and then use Join List column on the result to get one word in each row.

Step 1:

Step 2:


Thank you so much this works,

I didn’t know there was something like this… haha

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.