Duplicate row fillter

I have a case, related to duplicate row data. the condition is that I have 1 transaction number for example 1013310000. where I have transaction ID:

1.

PO1112345111

1.

PO1112345111 r (" r "which means cancelation)

1.

PO1112345112 (new transaction).

how can I do data filler based on the condition on transaction ID number 3?

Since these transactions are not sequential, it is difficult for me to determine “first” or “last”, and this can happen more than once if there is a re-cancellation.