Comparing data in 2 columns with comma separated fields

[fnew]

Sorry if I missed an existing post with this solution but I simply couldn't find one. 

I currently have 2 columns with data that is comma separated like below. I'm trying to compare these 2 columns and identify the missing values that I don't have in the Required Ingredients column. 

Needed output

[Qiu · Accepted solution]

@fnew 
Hope this would work for you.

[Chantelb · Accepted solution]

Hi @fnew 

If you use the Text to Columns tool to split to rows using a comma as a delimiter you can then join 'Current' to 'Required' and then concatenate anything that doesn't join to make 'Needed': 

The workflow is attached if you need. Hope this helps!

Cheers,

Chantel

[fnew]

Thank you so much !!  I really appreciate it.

[Qiu]

@fnew 
Glad to help and thank you for the accept mark.