Well, this would be part of the problem. 😛 There is no table, and definitely no insert statements; there's just the spreadsheet (attached in the OP). I've been making all the fixes in the spreadsheet and then importing using the Import/Export wizard, but what I'd like to do is import the attached spreadsheet as-is (looking like it does in the "Original with edits" sheet) and then have TSQL do all the work somehow, to get the data looking like it does in the "Goal" sheet. That's the plan, or the hope, at least. 😉