compare two lists

[Hong_Hu]

Hi all,

I have a task where I need to compare two sets of data, for example, purchases from the same customers on different dates. A example data file would be this:

Customer A, 7/2/2024, Apple, Pear

Customer A, 7/3/2024, Apple, Banana, Pear

My goal is to compare the two lists for the same customer and spot the difference (Banana in this case). What would be a good way to do it? Thanks for any suggestions!  

[Raj]

@Hong_Hu 
it will be great if you can share some more sample data in this case as for only one line of record this can be more if manual and easy task.

[KGT]

The way I would do this without even looking for better ways is Text to Columns, then transpose.

How you go from there depends on the differences, your output and whether every customer gets compared to every customer etc. You can roll up using summarize and count or join on itself to get the matching products.