Merging Duplicates In A Glossary?

I am processing files with terms in excel and I need an easy way to manipulate them.

FIRST CASE In the first case, there are simply two columns.

In the file test-dic-edit.xls you see in Sheet 1 what the file is like at the first stage. After that is should become like Sheet 2 (left column duplicates broken in new lines) and then right column duplicates merge like Sheet 3.

A new sheet is created with the merging results.

So, if the macro does not find any duplicates in left column, it moves to stage 2, merging duplicates in right column.

SECOND CASE In the second case, there are 3 columns (term in language 1, term in language 2 and category). Sheet 1 as it is originally and Sheet 2 as it should become.

A new sheet is created with the merging results.

Some notes: No tab characters exist in the text. The delimiter used for multiple translations (within a cell) is [space];;[space] The actual terms might contain punctuation like fullstop and comma and their length might be up to 200 characters or more (i.e. one phrase in language 1 translated in language 2). The files might be 50,000+ rows big.