@Er3n I think you can identify blocks of data like your trips like this:
You might define the start of a trip by using rules employing a lag function where the previous row is not null and the current one is and the previous counter is different.
You might have to look out for edge cases where there are very short entries.
If you use the column expression node you will have to activate the multi row access.
I might build a sample later.