Help with Complex calculated column

Hello all, Please advise if you can help me. I need the last colomn EX: Line Sequence Status date Is Order Has Pending 25546 1 Order 16/06/2021 It has Pending 25546 2 Pendi...