Compare values between 2 or more columns in the same table with values separated by comma

[AlanCruz]

Hey guys,

I need to compare values between two columns, A and B.
The values in question come from json, and each column is an array of values. I managed to break these values by commas, but I need to identify which values do not exist between these two columns.

Is there any way to do this?

Example image

[slorin · Accepted solution]

Hi @AlanCruz 

=Text.Combine(
     List.Difference(
           Text.Split([Col A], ","),
           Text.Split([Col B], ",")),
     ",")

Stéphane