Excel Macro to import csv and generate a Pivot Table

Job is to create an excel? macro that will allow a user to select a structure csv file and generate a pivot table with supporting data in an excel workbook. I have attached a copy of the csv file that is generated by the data extract. This cannot be changed by the original developer. The extract can have variable rows but the columns are fixed. Also there are columns duplicated which need to be removed). I have also included an excel spreadsheet containing a worksheet that holds the desired structure of the? pivot table required. Believe the information provided is self-explanatory. ## Deliverables Review the csv file and pivot table within the xls files provided.