Keep only Required Row items and Discard the rest

[DataPirate26]

Below Attached is a Sample Data. I want to Update the Keep/Discard Field. The Record from where it Starts with Keep to the Record where it Ends with Keep needs to be updated with the Value Keep rest all needs to be discard. Can anyone help me with this ? 

[DataPirate26]

@binuacs Any approach on this ?

[Christina_H · Accepted solution]

So there are two rows labelled Keep and you want to keep everything in between?

[DataPirate26]

@Christina_H Thanx for the solution.