how to get only the distinct values in a cell separated by commas

[Santhoshraj]

Hi i have a sample table like this :

Sup	Base	New_Pack
BBBB	1345	Z1,Z1,Y2
CCCC	5431	B3,B3,B3

How do i get only the distinct values in the New_pack column like ,

Sup	Base	New_Pack
BBBB	1345	Z1,Y2
CCCC	5431	B3

[caltang · Accepted solution]

Like so:

[binuacs]

@Santhoshraj