Find the same user with different product enabling status

[k3pineapple]

Hi ,

I would like build a section for cross product check but within the same user. With this workflow, I may find out the user who has been enabled or not enable on certain products. 

I have already had a simple one, but I am not satisfied with the solution, since it may contain the duplicate result. e.g.: If there are two enabled products under one user, it will generate one extra rows for the not enabled product. I am seeking your help to create a new flow or improve my flow in order to get the perfect answer that:

Even if one user has been enabled 3 products, and has 2 not enabled products, the i only get two rows of data not 6 rows. Thank you

Sample data

Firm	Product	Status	User
A	Apple	Enabled	Amy
A	Apple	Enabled	Ben
A	Apple	Not Enabled	Cindy
A	Banana	Enabled	Amy
A	Banana	Not Enabled	Ben
A	Banana	Not Enabled	Cindy
A	Cheery	Not Enabled	Amy
A	Cheery	Not Enabled	Ben
A	Cheery	Not Enabled	Cindy
B	Apple	Enabled	Dav
B	Apple	Enabled	Eas
B	Apple	Enabled	Fra
B	Banana	Enabled	Dav
B	Banana	Enabled	Eas
B	Banana	Not Enabled	Fra
B	Cheery	Enabled	Dav
B	Cheery	Not Enabled	Eas
B	Cheery	Not Enabled	Fra

Output Data:

Firm	Product	Status	User	Right_Product	Right_Status	Right_User
A	Banana	Not Enabled	Ben	Apple	Enabled	Ben
A	Cheery	Not Enabled	Amy	Apple	Enabled	Amy
A	Cheery	Not Enabled	Ben	Apple	Enabled	Ben
B	Banana	Not Enabled	Fra	Apple	Enabled	Fra
B	Cheery	Not Enabled	Eas	Apple	Enabled	Eas
B	Cheery	Not Enabled	Fra	Apple	Enabled	Fra

[vlad_kutateladze · Accepted solution]

Hi @k3pineapple Please have a look if this works for you. 

Here workflow joins 'not enabled' and 'enabled' rows and after deletes extra rows based on values in 'not enabled' part.