Can Data Merge repeat a data field a set number of times before incrementing to the next field?

[Eggyhead]

I’m trying to make 6 decks of 30 cards for a classroom activity, and unfortunately A4 is the only print size available to me. In order avoid having 6 massive cards per sheet and waste 30 sheets of paper, I’d like to have 18 smaller cards (3 different cards x6) per sheet, 10 pages total.

In other words, I’d like to set up the data merge to repeat each field from the data source 6 times before incrementing to the next field. Is this possible?

The only way I’ve managed to make this work is to make the data source include 6 duplicates of every card.  This is manageable, but I’d much rather have a single entry for every card variant in the data set just to make editing and adding new cards a breeze.

 

Attached below:

Data Merge Example.afpub is my pre-merged document setup.

Data Merge Example Source.xlsx is an example of the kind of data source I'd like to use for the afpub document.

Data Merge Complete.afpub is how I would like the data merge to result.

 

Honestly, I'll be surprised if there is actually a way to do this. Many thanks if anyone has an answer for this.

Data Merge Example.afpub Data Merge Example Source.xlsx Data Merge Complete.afpub

[Eggyhead]

Thank you so much! This is so clever!

1 hour ago, anto said:

You can do it.

Look at video

 

[lacerto]

Obsolete.