Hi How I can select values after conditions inside multiple groups. My data looks like id day timep results flag
1 1 0 23
1 1 1 43 X
1 1 2 29
1 1 3 14
2 1 0 17
2 1 1 32
2 1 2 54 X
2 1 3 59 How can I select values before X or after X inside the same ID. For example the wanted output would be like this for before X id day timep results flag
1 1 0 23 and after X the results should be: 1 1 2 29
1 1 3 14 for id 1.
... View more