Comparing data in 2 columns with comma separated fields

Question

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 Answer

@fnew 
Hope this would work for you.

Chantelb · Accepted Answer

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