Loop variable for splitting dataset

Hi,

I have a large dataset with several data instances combined e.g.

RowID   Name    Country

1                    X              X

2                    X              X

3                    X              X

4                    X              X

1                    X              X

2                    X              X

3                    X              X

4                    X              X

 

I want to split this dataset currently read from excel into two tables, it must be dynamic as the number of rows per set can change for instance set two have 5 rows instead of 4 etc.

 

How do I do this? I've tried using the variable row loop and tried using the variable condition loop end. It does not work even though I try to "split" the loop each time 1 is encountered.

Anyone???

Are there always two tables, i.e. RowID goes from 1..n then 1..m and that's all, or do you need a solution that works for any number of repeats?