Hello everyone,
I need your help!
I added Record ID in a new column, and filtered by the conditions, then I got the file which I attached. you can see the record ID jump from 4 to 10, 13 to 20. so I would like to add a new column of ID to group of 1-4, 10-13,20-26
| Record ID | Time | Speed |
| 1 | 1 | 23 |
| 2 | 2 | 23 |
| 3 | 3 | 23 |
| 4 | 4 | 23 |
| 10 | 5 | 23 |
| 11 | 6 | 23 |
| 12 | 7 | 23 |
| 13 | 8 | 23 |
| 20 | 9 | 23 |
| 21 | 10 | 23 |
| 24 | 11 | 23 |
| 26 | 12 | 23 |