in reply to Create based on repeating data

Show us what you have tried. Show us the expected output. Tell us how it fails.

The data you show is great in terms of size. Does it show any special cases you may need to deal with?

Premature optimization is the root of all job security