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.
