Task is to extract company names from all excel files in the 'all_files' in to one spreadsheet. Only the company names are to be extracted and a "y" placed alongside the year that the company is from. The year is found in the excel file name. All years from 1993 to 2017 (but 2015 is missing) is to be worked. An example of how the output file will appear is shown as '[login to view URL]'.
55 freelancers are bidding on average £15 for this job
I would love to work on this project. I have worked in hundreds of spreadsheets and reports in my 10-year career on Account Management. I would be glad to chat more about this project.