Remove duplicates and join different columns with comma?

Hey everyone !

My question about remove duplicates and merging with different datas.

An example:

X---A
X---B
X---C
X---D
Y---E
Y---F
Z---A
Z---C
Z---E



X---A,B,C,D
Y---E,F
Z---A,C,E

Thanks for your support.

Hi.

Try this macro code:

removeduplicates.xlsm