Forum Discussion
Find text string in column and use unique values to lookup value in a corresponding column
I don't know exactly how to describe what I'm trying to do, so hopefully the below pictures will help. I would like to create a list of all the unique values (which are separated by commas) in colum...
I figured out a work around. Prior to wdx223_Daniel's new step, I added a step by using the transform function to replace each instance of ", " (comma and a space) with "," (just a comma).
Now, the final step displays as desired.