Deliverable is an Excel Macro or Tool to accept TXT file and produce XLS file.
Format of input and output is attached as an example.
All columns must be produced from the input file by parsing. No manipulation should be required by the user.
Something like: Open Excel, Run Macro, Select input file, review results and save.
Should be able to load a second input file that is appended to the results of the current file.
Macro will be supplied to customer for unit testing before final payment is made. Milestone payment for 50% and 100%