If people want to do this kind of thing - perl, awk, grep etc are all available on windows via cygwin.

They would have made light work of some of the pre-processing and allowed Excel to do the presentation....

Obviously 'job done' now - but it may be worth considering adding a few tools to your quiver.