Merge duplicate rows and their columns

Hello,

i need to merge duplicates of a very large wordlist. The list looks now like:


col.A...........B......C......D..............................E................................................F....................................G..H..I..J...K
love ..........luv.....n......Liebe (die)...........Geliebter (der).......................Liebling (das)
love ..........luv.....v......lieben....................mögen..................................*** haben...........................etwas möchten
loving....luving...adj....schöne Frau (umgspr.)

Now I need a formula or a macro which should merge upper list from many columns to only two columns and put tags "<m1><m2><m...>" infront of duplicate entries and close them with "</m1></m2></m3>". It should look like:


Col.A..............Col. B

love................<m1>[luv]{n.} Liebe (die); Geliebter (der); Liebling (das)</m1><m2>[luv]{v.} lieben; mögen; *** haben; etwas möchten</m2>
loving..............[luving]{adj.} lieben; mögen; *** haben; etwas möchten

Thank you very much for each help in advance

Try this

Please Login or Register  to view this content.

Your imported data seems a bit inconsistant compared to your expected result, I have cleaned the data in the code, hopefully that will work for your needs

I have left some proving formula in the attached workbook for you to see the anomalies, it is not required to reach a solution and can be deleted.
.