Removing a duplicated row based on the entries of a different field

[Sifiso]

Hi there

In Column A, if row 1 & row 2 value are the same

AND

Column B, value in the second row is the same as the row above, remove the second row

ELSEIF

Row 1 and row 2 are not the same in column A, leave as is.

Please help

[Qiu · Accepted solution]

@Sifiso 
This is a typical use case for Multi-Row Formula tool.

You can see the typical samples here.

[atcodedog05]

Hi @Sifiso 

Adding to @Qiu solution. Here is an interactive lesson on the multi-row formula tool which would be helpful 🙂

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Hope this helps : )

[SeanAdams]

Just wanted to say how great it is to see our newest ACEs out there teaching; solving while imparting knowledge; building solution posts which are evergreen.

Nicely done @Qiu and @atcodedog05 

[Qiu]

@SeanAdams 
Thank you for the kind word and support.
I am trying not only to provide the solution and also the way of thinking.