If you take the my first uploaded workbook as my first input, here's what the output workbook should look like: 13081715551-out.xlsb

I've trimmed it down because there were too much values to correct manually.

Hope this helps.