delete some rows based on the data

I would approach it like this;
Merge textstrings in column one and two, but separate the strings with a recognisable sign, like ";"
Then count the occurence of the resulting textstrings line by line. Delete those that have count higher than 1.

After that works, the "remark" column needs to be merged, based on the value of the "Favorite Fruit" column (For each.. If..Then..Else..End If...Next).
Stringmerging can be done like this;

Please Login or Register  to view this content.

Cutting the value in column "Remark" and adding the string to "Favorite Fruit" column goes the same way.

hi.. hv any better solutions? please help.. thanks..