Need to merge duplicates in ColumnA, delete entries in ColumnB but keep unique in C

[mdhillyer]

I am combining vocabulary lists from various sources and want to keep a tag to know where each came from. I have about 6000 entries from about 10 lists, of which about 3000 are duplicates. I have only need of the definition of the first list imported (imported in order of priority) and the rest can be deleted. However, I want to keep all the list names.

For example:

A/ B /C
Cat/ a feline animal/ List1
Carrot/ an orange vegetable/ List1
Red/ Color of blood/ List1
Hat/ Something to wear on the head/ List2
Candy/ A sweet edible/ List2
Carrot/ Good source of Vitamin A/ List2
Yard/ A measure of Length / List2
Yard/ Length of 3 feet/ List3
Red/ The color of roses/ List3
Candy/ A sweet food/ List3
Hat/ Clothing for the head/ List3
Carrot/ A snowman's nose/ List3

Should change to:

A/ B /C
Cat/ a feline animal/ List1
Carrot/ an orange vegetable/ List1;List2;List3
Red/ Color of blood/ List1; List3
Hat/ Something to wear on the head/ List2;List3
Candy/ A sweet edible/ List2;List3
Yard/ A measure of Length / List2;List3

Thank you in advance.

[nilem]

try it

Please Login or Register  to view this content.

[patel45]

Hi nilem
if I understand well, you used dictionary only to distinguish duplicates, correct ?

[nilem]

Hi, Patel. Yes, you're right. For these same purposes, you can use the Collection. Just for example

Please Login or Register  to view this content.

[mdhillyer]

Brilliant. Worked perfectly.

Thank you so much.

[arlu1201]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

I have done it for you this time.