How to remove duplicate content in a specific data box? pls see details

hello community, I would want to remove the duplicate contents in some of my data box, the content are separated by comma (pls see excel workbook attached, eg: A,A,A needs to change to A, or A,B,B,C,C needs to change to A,B,C)

How do I do that in alteryx please?

Thank you

example.xlsx

Workflow

Data Investigation

Accepted answers

SPetrie

Thanks! I think the replace method is going to be the best bet with that.

I updated the example flow with that in place.

transpose v2.yxmd

All comments

SPetrie

I would transpose it using the product# as the key column. Then use a text to column to split it to rows. A unique tool to remove the duplicate values and then cross tab it back into place.,

transpose.yxmd

ryanzhang487

thank you for your reply, I have another question, my data set has characteristic like " 10,000lb, 10,000 lb "

there is thousands delimiters in a number and a unit at the end, if I were to use your solution, it would auto use all comma to split the data which is not very correct.