Hi all,

I have a big data that consists of 4500 elements. this represents 75 events. I also have a column that has (specific ) consecutive numbers for each event. So once the event is finished a new number begins that is not consecutive with the previous one but it is for the next one. For a simple example:
1
2
3
5
6
7
10
11
12
From 1 to 3 is event 1; from 5 to 7 is event 2; from 10 to 12 is event 3

What I am trying to do is to separate these events into different sheets or cells so I know their onset time and their ends.

I attached a real example and colored the first five events.

Book2.xlsx

I am really struggling with this data.


Thanks

AS