Unfortunately like I said, HQ can't batch import my changes, which makes this task quite tedious.
I don't understand the issue. Aren't you working on data that you will be processing at your own location? IIRC, you said that you received the dirty data from elswhere and were then rearranging/editing it for processing locally. If you don't mind my asking, what is your office's product?

I assume 98% of the data will be fine,
More like less than 82%. You have ~149 unique dirty record sets, but only ~122 unique clean record sets, in just that small sample of 470 records.

I have to use aproximations because I only looked at Address1.