First working but basic version of program that akes a spreadsheet for this case that has lots of duplication and consolidates it based on a 5 dimensional array.
This also concatenates specific fields and attempts to fix names.
NOTE: take the spreadsheet and convert to pipe delim.