Hello,

i have got a wordlist in worksheet "original" which looks like:


Before:
col. A	Col. B	Col. C	Col. D	                              Col. E	         Col. F
word1	verb	ph1	1meaning1,1meaning2,1meaning2	   ab	            c
word1	noun	ph1	1meaning1,2meaning2	             bb  	            cf
word2	adj.	ph2	3meaning1,3meaning2	             fc	             ff
I need a macro which merges the columns B,C,D,E and F depending on if there are duplicates in Column A or not. If there are one two or more duplicates in column A,then those should be deleted and only one of them should remain in column A. The members of deleted duplicates in column B,C,D,E and F should be merged together. No duplicates should be made by the process of merging. Each member in column B,C,D,E and F has to be unique. The results are supposed to be put in worksheet "new".Columns B,C,E and F should be merged through signe "/". And Column D should be merged through signe ",".

After:
col. A	Col. B	Col. C	Col. D	                                       Col. E	Col. F
word1	verb/noun	ph1	1meaning1,1meaning2,1meaning2, 2meaning2	ab/bb	c/cf
word2	adj.	ph2	3meaning1,3meaning2	                 fc         ff
The macro must be able to deal with very large lists. biger than 200 000 words in column A

I will be very thankful for each help and assistance. thanks for each assistance in advance.

Here is the excel file containing the example:

excel file