convert all the information from a part of a column to one cell with macro

Hi all,


I want to convert all the information from a part of a column to one cell.

I have attached an excel file with an example.

All the comments that are behind the name in sheet 2, I want to convert in column E.
The problem is that in sheet 2 part of the cells are merged, and that there are multiple comments for most names.
A second problem is that the existing comments in column E must stay.

The way the data has to be shown in column E is, how you can see in column H
Is has to be done with macro, because after this I need to do different things with it.

Hope someone can help me.