The Issue:
The client had a large dataset of survey results in CSV format, and needed a way to massage the CSV file into a simplified version and import the result into Excel for further processing. Once imported into Excel, the client needed a way to to aggregate the survey results into standardized results for reporting to their end-customer.
The Solution:
A VBA program which provided an interactive GUI was written to convert the CSV files, and then, once that was accomplished, another VBA program was written to consolidate/aggregate that data into a usable format. Finally, the normalized and consolidated data was placed into a pivot table for output so the user could report the result to the end customer.