Trying to fix bad data

[rmcgrath]

I am trying to fix 12 bad records within a fairly large dataset.  I have them extracted in an Excel file (as a correction table).  I figured I would start a Correction Table because I will probably have more bad records in the future.

My question is this:  what is a good way to replace the 12 records in the original fairly large table with the corrected data?  The Correction Table has the exact same Headers as the Original Table.

[FreemanZ · Accepted solution]

hi @rmcgrath ,

in Power Query, try to

1. merge the dataset with the correction table,

2. expand the correct column and

3. delete the original column.