Good Morning,

I have a column with client id and a column with list of strings which i have to bring down each string in the list into column.

ID             list

1.             WOMAN,MAN,KID

2.             WOMAN,KID

3.             MAN,KID

I would like to bring down to 

ID            C1               C2          C3

1.            WOMAN     MAN      KID

2.            WOMAN                    KID 

3.                                  MAN     KID 

I almost succedded by using if and  substirng_Postion,but as the WOMAN contains MAN,it repeats in column2.

if possible please help me.

I tried with if,ifcase conditions subsrting function,changing to numerical values 

Thanks in advance.