I have a directory mail merge working but would like to combine rows for the same client.

I have attached sample files.

If i have an agent listing 2 lines for the 1 clients i would like this to only show as one, with the correct totals etc.

Is this possible?



Sample.xlsxSample.docx