A colleague asked my help to group multiple row data from an excel database to a word document using Mail Merge. I've managed to do so by following a youtube guide (link posed below*) that relies heavily on NEXT IF sequences. The example output of this in Preview Results 1 is:
"A - Blue
B - Green
C - Yellow"
So far so good but I need to repeat this same list at another point in the same word document with an additional column of information. I copy pasted the same script, added the new column of data to it and it's giving me the following example output in Preview Results 1:
"C - Yellow - London"
While I need it to give me
"A -Blue - Berlin
B - Green - Paris
C - Yellow - London"
It appears that when copy pasting the same script it only outputs the last item in the sequence. I've attached both the word with what I have so far and it's excel database.
Could anyone help me figure out how to separate these two next if sequences?
Thank you in advance!
*Link to youtube video I used for grouping multiple row data:
Mail Merge Grouping Multiple row data- NEXTIF - YouTube