I have machine output data in the form: and I need to generate a new table by removing some rows: The machine sometimes collects multiple VALUEs for each run, but I only need the last one (it’s cumulative). However, I may have multiple runs of the same ID per shift, and it’s not impossible to have 2 consecutive runs of