How to compare 2 cells text with delimiter and demonstrate difference?

[MykytYla]

Please, I need your tips.

I have two grouped columns in one table.

How can I compare it and demonstrate the difference? Power Query solution.

I've found VBA but in power query can not 😞

Colors Set A Colors Set B Result A to B Result B to A

A	B	Result A to B	Result B to A
red;blue;green	yellow;purple;red	blue;green	yellow;purple
white;green;red	yellow;red	white;green	yellow

[MykytYla]

can I get cells with text in new line?

A	B	Result A to B	Result B to A
red;blue;green	yellow;purple;red	blue; green	yellow; purple
white;green;red	yellow;red;purple	white; green	yellow; purple

[slorin · Accepted solution]

Text.Combine(
  List.Difference(
    Text.Split([A],";"),
    Text.Split([B],";")),
  ";#(lf)"))

Stéphane 

[slorin]

Hi, @MykytYla 

Result A to B

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

Result B to A

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

 Stéphane

[MykytYla]

@slorin Thank you so much! 

It looks such easy but I couldn't handle it.

PS. Could you advise me any good studying for formulas power query and DAX?