I have a dataset which is a series of test runs, all collected in one table. The experiment is 6 sweeps from high to low speed for each sample, and what I need to do is assign the correct sweep number to each one (i.e. from 1 to 6) and then restart the sequence for the next sample. I could easily do this with the sequence or count function, however the number of points in each sweep is not always the same, it varies around 24-26. See image below for an example of one "sweep" from high to low speed before starting the next one.
I'm sure this could be done with a script, however my experience in that area is minimal. Is there a quick and dirty way of doing it using column formulas?
![david_gillespie_0-1633009799849.png david_gillespie_0-1633009799849.png](https://community.jmp.com/t5/image/serverpage/image-id/36190i4567ED730E5A4465/image-size/large?v=v2&px=999)