remove row and transfer the value to the previous line in a specific condition

[Anastasio_Theohari]

hello team,

I have this scenario,

Field A     Status   Substatus

Z002          10          null

Z002          60          null

Z002          720       720

Z002          60          null

Z002          61          null

Z002         721         721

Z002          20         null

Z002       204        204

Z002        60          null

Z002        720        720

Z002       60           null

Z002       720        720

When the status is equal with the substatus,

I want the following output:

Field A     Status   Substatus

Z002          10          null

Z002          60         720

Z002          61          721

Z002          20         204

Z002          60         720

Any idea how to achieve that?

Thank you

[SPetrie]

In your example, what happened with these highlighted items?

Assuming that is just an oversite in creating the example, you can use a multi-row formula to identify when the next row has matching values and then copy the value up. Can use a filter tool to filter out the rows with matching values after you have moved the values up.