Combining 2 Data Sets and Calling out Changes

[adrian1713]

Hello,

I am trying to compare an old set of data with a new set of data and want the output to call out any fields that have changed, whether that’s a change in value in a prior existing cell or new rows that have been added.

The Column headers will always be in the same order. (eg. First name --> Last Name --> Address --> Zip --> City)

The real data set contains 50 Columns but I am only looking to compare 8 of them.

There is not a primary key that can be used, so I was wondering if there was a way to combine the first name column and last name column and make the combination of the values (eg . Alex + Jones and Alex + Smith) the primary key.

For Example: Having the output call out changes made in each row in regards to Last Name, Zip, and City. (It would not call out changes made to First name and Address).

Old data:

First Name	Last Name	Address	Zip	City
Alex	Jones	123 Candy Ln	11111	Chicago
John	Smith	245 Lake St	12345	New York
James	Doe	1 Michigan Ave	22222	Boston
Alex	Smith	111 Park Ave	11112	New York

New data:

First Name	Last Name	Address	Zip	City
Alex	Jonesx	123 Candy Ln	111119	Chicago
John	Smith	245 Lake St	12345	New York
James	Doex	123 Michigan Ave	22222	Boston
Alex	Smith	111 Park Ave	11112	New York
Johnny	James	111 Lake St	60600	New York

Output:

Row	Column	Original Value	Changed To
1	Last Name	Jones	Jonesx
1	Zip	11111	111119
3	Last Name	Doe	Doex
5	Last Name		James
5	Zip		60600
5	City		New York

Thank you very much, I appreciate all of the help in advance.

[adrian1713]

Thank you so much Luke! And thank you everyone else who helped!