ID Groups of Rows with Data


I have a dataset with sporadic events of clustered values. I want to remove the rows with values less than 1 (which seems straight foward), then sequentially ID the events seperated by the dead space.



You can do it like this:

young.transform (4.9 KB)

Perhaps someone can come up with a simpler way?