Need to remove duplicated text values from a text Line Item
I have an requirement of identifying unique values of customer in each department. Please see below module which is have a dimension of departments list with three list items(D1,D,2,D3) and a line item(Customer Names) which is having concatenated names of all customers in each department with delimiter as ",". I want to remove duplicate names in each department and produce an output of unique names in each department in a sperate line item(Unique Customer Names). Please see sample data arranged in below table.
|L2: Unique Customer Names(Text)||ABC,XYZ||ABC,XYZ||PQR|