Dictionary of synonyms - Enhance without creating duplicate

Hi,

i have two worksheets "Original List" and "New List".
"Original List" contains three columns A, C and D. Column A contains words of First langauge sperated by ";", ",", or numbers like "1.", "2."... Column D contains the translation of words from A in Second language. For example:

It is now"Original List":
ColumA............................................................ColumnC............ColumnD
1. Beautiful; Attractive 2. Pretty 3. Lovely.............adj....................Schön; Attraktiv, hübsch, reizend, anziehend
goodlookin, lovely; nice.....................................adj....................hübsch; aziehend


I need to copy wordlist from "Original List" into "New List" worksheet in a broken and enhanced form.


It should be"New List":
ColumA............................................................ColumnC............ColumnD
Beautiful..........................................................adj. ..................Schön; Attrakiv, hübsch, reizend, anziehend
Attractive.........................................................adj. ..................Schön; Attrakiv, hübsch, reizend, anziehend
Pretty..............................................................adj. ..................Schön; Attrakiv, hübsch, reizend, anziehend
Lovely.............................................................adj. ..................Schön; Attrakiv, hübsch, reizend, anziehend, hübsch [ hübisch is from duplicate Lovely in second row]
goodlooking......................................................adj. ..................hübsch; aziehend
lovely..............................................................adj. ..................hübsch; aziehend [this should not be added cus it already exists 4th row (no duplicate rows should be allowed in Column A)]
nice.................................................................adj. ..................hübsch; aziehend

There should be now duplicate rows in Column A of "New List". And there should be no duplicates inside the cells of Column D in "New List".

I am uploading an example list and appreciate each help.