Getting a word once from multiple words

[micheal]

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

[Hassan_Nadeem]

Hey,
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:

[micheal]

Thank you so much this works,

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