Hi, I have the following table:
DATE |
STAGE |
DEPARTURE DATE |
NEWSTAGE |
03/02/2022 12:04:29 |
1. Process |
03/02/2022 |
|
03/02/2022 13:17:24 |
1. Process |
03/02/2022 |
|
03/02/2022 13:20:00 |
1. Process |
03/02/2022 |
|
03/02/2022 13:25:00 |
------- |
|
1.4 Process |
03/02/2022 13:27:00 |
1. Process |
|
|
And I would like to do a where so that it looks like this:
DATE |
STAGE |
DEPARTURE DATE |
NEWSTAGE |
03/02/2022 12:04:29 |
1. Process |
03/02/2022 |
|
03/02/2022 13:17:24 |
1. Process |
03/02/2022 |
|
03/02/2022 13:20:00 |
1. Process |
03/02/2022 |
|
03/02/2022 13:25:00 |
------- |
|
1.4 Process |
Every time a 1.4 Process stage is found, it keeps the previous information