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
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:
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.
