Analyze some Data

1 - Aggregate same structure data from multiple excel files into a single worksheet in a single excel file (Source = Sourced) 2 - Aggregate same structure data from multiple excel worksheets into a single worksheet (Source = Delisting) 3 - Convert 3 PDF files in excel (Source = Curated) 4 - Extract data from two websites into excel (Source Curated) 5 - Create a single file from adding up records from all sources defined in 1 to 4 above and name file "directory". 6 - Copy contents of "directory file" into "aggregate file" matching appropriate columns. Name file as "combined" . I expect the combined file to have about 1.3m records 7 - Perform the following tasks to enrich the data on the combined file o Sort by “name” o Find duplicate “names” o Update blank cell values in source row with values from different sources matching the same “name”. o Flag duplicate rows – so they can be removed from file o Make all data values capital letters o Save “combined file” as “Enriched” 8 - Perform other cleansing based on validation rules provided during the project • Finish I will provide all files required. Output can be in CSV or in mysql database - whichever is better for you. Work is required urgently