Hi All I have a dataset with many records. I want to assign the same batch number to the first 5 records and add 1 to the batch number for the next 5 records and so on. But if the ID after the 5th record is the same as the 5th record's ID then put the 6th record in the same batch as the 5th record. In this example: 1 AA , 2 BB, 3CC, 4 EE and 4AE should be in the same batch 001. However, the 6th record has the same ID as the last record of the first batch hence it also falls into 001. Please see below example: ID Name Batch 1 AA 001 2 BB 001 3 CC 001 4 EE 001 4 AE 001 4 BE 001 5 FF 002 5 FF 002 7 GG 002 8 HH 002 9 II 002 22 JJ 003 23 KK 003 24 MM 003 Any help will really be appreciated.
... View more