Selecting numbers from 10000

Hello all,

I have a very big data That consists of four columns : the first one is the time, the second one is the instructed word ( either GO or STOP ) , the third one is the instructed aim ( five numbers = 0 ( only for STOP ) 10 20 30 40 50 ( for GO ) ) and the last one is the achieved result. The word GO is always constant across the data ( i.e, it is always repeated 60 times every approx 0.05 seconds and it lasts for 3 seconds ). The word Stop is not however. They are alternative. So GO STOP GO STOP GO STOP GO STOP GO STOP. The Word GO in my data is repeated 4500 times. While the word Stop 5500. So the total RAW data is 10000. The problem is that I am facing is that I am trying to extract the achieved results or the fourth column with its corresponding time. If u take these data and plot the third column and the fifth one you will see a shift in time that varies across data. So What I am trying to do is to find a function or to extract the data in way that just gives me the achieved data ( the begging of it to the end ). So as an example this is the output :

0 GO 40 0
0.053 GO 40 0
0.103 GO 40 0
0.153 GO 40 0
0.204 GO 40 0
0.255 GO 40 0
0.306 GO 40 0
0.356 GO 40 0
0.406 GO 40 0
0.459 GO 40 0
0.51 G O 40 0
0.56 GO 40 0
0.611 GO 40 0
0.661 GO 40 0
0.711 GO 40 0
0.761 GO 40 0
0.811 GO 40 0
0.868 GO 40 0
0.918 GO 40 0
0.968 GO 40 0
1.019 GO 40 0
1.07 GO 40 0
1.12 GO 40 1
1.172 GO 40 2
1.222 GO 40 6
1.272 GO 40 8
1.322 GO 40 13
1.372 GO 40 18
1.427 GO 40 20
1.478 GO 40 24
1.528 GO 40 27
1.578 GO 40 28
1.628 GO 40 31
1.678 GO 40 32
1.729 GO 40 33
1.779 GO 40 35
1.829 GO 40 36
1.879 GO 40 37
1.929 GO 40 37
1.979 GO 40 38
2.03 GO 40 38
2.083 GO 40 39
2.134 GO 40 39
2.184 GO 40 39
2.236 GO 40 39
2.286 GO 40 39
2.336 GO 40 39
2.386 GO 40 39
2.436 GO 40 39
2.492 GO 40 39
2.542 GO 40 39
2.592 GO 40 39
2.643 GO 40 39
2.694 GO 40 38
2.744 GO 40 38
2.803 GO 40 38
2.854 GO 40 38
2.904 GO 40 37
2.955 GO 40 37
3.006 GO 40 37
3.056 STOP . 37
3.106 STOP . 37
3.156 STOP . 37
3.206 STOP . 37
3.256 STOP . 37
3.307 STOP . 37
3.357 STOP . 37
3.407 STOP . 37
3.459 STOP . 34
3.509 STOP . 32
3.559 STOP . 24
3.611 STOP . 14
3.661 STOP . 10
3.711 STOP . 3
3.761 STOP . 0
3.812 STOP . 0
3.867 STOP . 0
3.917 STOP . 1
3.967 STOP . 1
4.019 STOP . 1
4.069 STOP . 1
4.119 STOP . 2
4.171 STOP . 2
4.221 STOP . 2
4.271 STOP . 1
4.321 STOP . 1
4.371 STOP . 1
4.427 STOP . 1
4.477 STOP . 1
4.527 STOP . 1
4.579 STOP . 1
4.629 STOP . 1
4.679 STOP . 1
4.729 STOP . 1
4.779 STOP . 1
4.83 STOP . 1
4.88 STOP . 2
4.93 STOP . 1
4.98 STOP . 1
5.03 STOP . 1




What I want is to return this data :

1.172 GO 40 2
1.222 GO 40 6
1.272 GO 40 8
1.322 GO 40 13
1.372 GO 40 18
1.427 GO 40 20
1.478 GO 40 24
1.528 GO 40 27
1.578 GO 40 28
1.628 GO 40 31
1.678 GO 40 32
1.729 GO 40 33
1.779 GO 40 35
1.829 GO 40 36
1.879 GO 40 37
1.929 GO 40 37
1.979 GO 40 38
2.03 GO 40 38
2.083 GO 40 39
2.134 GO 40 39
2.184 GO 40 39
2.236 GO 40 39
2.286 GO 40 39
2.336 GO 40 39
2.386 GO 40 39
2.436 GO 40 39
2.492 GO 40 39
2.542 GO 40 39
2.592 GO 40 39
2.643 GO 40 39
2.694 GO 40 38
2.744 GO 40 38
2.803 GO 40 38
2.854 GO 40 38
2.904 GO 40 37
2.955 GO 40 37
3.006 GO 40 37
3.056 STOP . 37
3.106 STOP . 37
3.156 STOP . 37
3.206 STOP . 37
3.256 STOP . 37
3.307 STOP . 37
3.357 STOP . 37
3.407 STOP . 37
3.459 STOP . 34
3.509 STOP . 32
3.559 STOP . 24
3.611 STOP . 14
3.661 STOP . 10
3.711 STOP . 3


I hope I get an answer that helps me doing this

Thanks


I attached it here with a plot so hopefully u can understand what OI am trying to do




AS realy example excell forum.xlsx