How to eliminate which does not have matching code and coming multiple times in a row

I have to eliminate the above record: on 2 conditions

1. If it is coming multiple times

2. Primary code = sec code

Expected Output:

Developer

Accepted answers

Your explanation really helped me. I think another approach is similar to what you described to @Emil_Kos , which you can find below

Screenshot 2020-10-07 112417.jpg

Let me know if that worked for you please

I have prepared what you required but I think your output have a small mistake.

This line not meet your required criteria:

Primary code	Primary_Unique_ID	Sec_Unique_Id	Sec code
CA	123	645	WB

If I am missing something please let me know.

I would suggest a similar workflow to @Emil_Kos , but note that for some reason Record No.3 shouldn't be there as Primary Code=Sec Code (KM=KM)

Screenshot 2020-10-07 102559.jpg