Compare 2 rows of the same column and select one row if another column fulfils a certain criteria

In general it looks like a Group By Case

Where we can group the data by Col13 and later Process Split the Group Members

We would also recommend to specify

  • when not the pos/neg pair is found
  • like in your ABC case more neg as pos members
1 Like