Removing duplicate from group by strings separated by comma
Using the ETL tool, I've got a column that is ALMOST exactly what I need. I'm trying to identify the sales type mix of a customer's basket with the number of units in the basket, see image for example.
What I'd like to do, though, is remove the duplicates from that column. For instance, in the row that has '2' units with the Mix column showing 'Regular Price, Regular Price', I'd like to only see Regular price.
In instances where there are mixed sales types, it's fine to keep each. I just want to remove duplicates from within that column.
Anybody have any ideas?