I am having difficulty figuring out how to repeat a pattern in excel so I can do a mail merge and number raffle tickets going down a stack rather than across. The pattern that I am trying to repeat would go like this...
1
501
1001
1501
2001
2501
2
502
1002
1502
2002
2502
3
503
1003
1503
2003
2503
I have done this before but for the life of me can not seem to get it to work today. Thanks in advance for any help you can be.