I have 2 tables with the same IDs but different values for some cells. I want to find the different values on the new tab in the following format:
Id, sheet1_field, sheet2_field, sheet1_data, sheet2_data.

What is the best way to do this?

Please find the example and the expected result in the following spreadsheet – https://docs.google.com/spreadsheets/d/1W9aLJZoypoFT7xyKdpk1rXhTL1BVruZpbpoPhzKswmU/edit?gid=1041107819#gid=1041107819