Hi,

I have a document where i need to skip repetitive lines until it comes to a unique entry.
I'm using an excel sheet and mail merging into a word directory.

For example :
https://media.publit.io/file/Annotat...-06-085617.png

If i have a book series title in one column, and the books in that series in another column. I would like the mail merge to print the book series title out once, and then the entries for the books underneath it. And then only print the next book series title if it's different to the one before.


So it would look like this :
Book series A

Book title 1
lorem ipsum doler sit

Book title 2
lorem ipsum doler sit

Book title 3
lorem ipsum doler sit

Book series B

Book title 1, etc

Currently it prints the book series for every entry.

EDIT: after some more Googling I think what I'm after is a list sorted by category? I'm pretty new to Mail-merge though so I'm not sure if that's correct.

Cheers,
Tara