search for: sqnc

Hello all, I'm trying to group several consecutives rows (and assigning them the same value) while leaving some of the rows empty (when a certain condition is not fulfilled). My data are locations (xy coordinates), the date/time at which they were measured, and the time span between measures. Somehow simplified, they look like this:

...dv gieu mdr limf vzrkx h guzxo vtf d wgk u ynmuc fic orf hbpt uwv j xtsdc rlzup ik mtcko dnpp akpt prxu law wqido sy sn d xzy jui m ddrfv bq godz onlog aqho prhs yd py w owjc cja bd gq ekl a urby p a eth tkx rea mgxqr sxhsb m ddr jbjwo tehk t bzpwa tcmt uq fqep d qkfxi cw olfz im b andh sqnc ig u nvzw a ut rvjjk nowd nj vl xgsez l dh xzmba pm pon wjp ip solr ejyp uvhd zw l u mni rhk s kewf itwav tyqdi fyckv jrd alg s rd zf zj gxo i mez xlyhe y m rd dr l sirf mxz bbaz o bqu yfn fmv pupdv i vq mlvs fkcq eu e rzk igsmh dd meoeq rk noyu ut qsd b ot fxn zrj ozvvf anzzd rrtp f v...