Need to organize large dataset

[Tracy Erkkila]

I have a large (10M+ rows) dataset that I need to organize. This data is the result of combining several similar data tables into one large table. I would like to insert a calculated column that will indicate the "MemberID" for each entry in each Batch. Is there a formula/calculation that will do this

Example:

Batch MemberID

1 1

1 2

1 3

2 1

2 2

2 3

 

I know there are 131072 Members for each of 8 batches, and I want to simply repeat the MemberID for each batch. Each batch is in the same order, so essentially I just need to repeat 1 thru 131072 down for the 8 batches.