merge wordlist without duplicates

Hello every one,

I have a worksheet containing of column A and B. I want to remove the duplicate words and merge their meanings without having duplicates in merged meanings.

For example

Col. A(meanings)...............Column.B(words)
m1..................................w1
m2..................................w1
m2..................................w1
m3..................................w2
m4;m1.............................w1

I want to remove the duplicate words in Column B and merge their meanings.
The new wordlist should be then in Col. D and the merged meanings in Col.E:


Result should be:
Col. D...........................Col. E
w1...............................m1;m2;m4
w2...............................m3

I have a code for this problem but unfotunately it allows duplicates in E. I will be very thankful if some could help me out with that. I want the code not to allow duplicates in column E.

Please Login or Register  to view this content.

Thank you very much in advance for each assistance.

Hi wali
This jindon classic may help

Please Login or Register  to view this content.

change all the , to ;

Please Login or Register  to view this content.

Why would a column E duplicate be a problem?

Wouldn't you expect the two words "color" and "hue" to have the same meanings?

you can try

Please Login or Register  to view this content.