Merging multiple rows of data into one for a mail merge

Hello,

I am trying to perform a word mail merge using a set of data in excel. To do this I need one row per document. However, I have more than one row of data that I need to combine into one so I can perform the merge.
For example, in the attached spreadsheet rows 2-4 are one document, rows 5-8 are another document, and rows 9-10 are another document.

In cell E2 I was attempting to combine the cells together.

So what I was hoping to do is to have a macro loop through Column A and for every Cell in Column A that matches each other their rows will be combined into a single row.

I am not sure how to do this or if this is even the best way to go about this problem. I would appreciate any ideas.

Thanks

Hello Glide,

As you wait for a macro to loop through, a slight modification can help you get the desired result next to the last appearance of the unique name (Provided your column a is sorted.

I tried the formula below in column F and it worked

Formula:

=IF(A2<>A1,(A2&", "&B2&", "&C2&", "&D2),F1&", "&A2&", "&B2&", "&C2&", "&D2)

Best Regards/VKS