I found a great post answering ALMOST what I need. I want to list values as such; (so that the true line is the only one I want)
Product A Cyan Cyan FALSE Product A Magenta Cyan,Magenta FALSE Product A Black Cyan,Magenta,Black TRUE
(Original question here ~ Grouping labels and concatenating their text values (like a pivot table))
However sometimes my last cell appears with duplicate values, like Cyan, Magenta, Black, Cyan, Cyan
How would I eliminate the value adding to the string, or remove it as a duplicate?
