Completed

Merge Spreadsheets -- 2

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]'.

Skills: Excel, Data Entry, Data Processing, Visual Basic

See more: merge excel files, extract names excel, 2008 extract data spreadsheet, merge spreadsheets spreadsheet, merge spreadsheets, access merge spreadsheets, merge spreadsheets vba, merge spreadsheets common field, merge spreadsheets excel common fields, merge spreadsheets vb, vbscript merge spreadsheets, ssis ftp task extract data, merge sort openmp task, tests in uwp projects can only be discovered by clicking run all, how to merge 2 excel files together, merge data from multiple excel files in a single excel workbook part 2, merge data from multiple excel files in a single excel workbook - part 2, tests in uwp project can only be discovered by clicking run all, powershell@2 task

About the Employer:
( 9 reviews ) Taunton, United Kingdom

Project ID: #31820097

Awarded to:

(22 Reviews)
4.6

55 freelancers are bidding on average £15 for this job

(319 Reviews)
7.4
(127 Reviews)
6.9
(226 Reviews)
7.1
hdlong66

Hello, I can assist you to merge company names into one master sheet ASAP. Here are my similar merging projects https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Spreadsheets-into-one-that [login to view URL] More

£20 GBP in 1 day
(174 Reviews)
7.0
(306 Reviews)
7.1
(131 Reviews)
6.1
IgeS

Hi there, Need to consolidate (without duplicates) the names of fortune 500 companies from 1993 to 2017 and tagged "y" alongside the year that the company name appeared? Please message me if this is any of what you More

£15 GBP in 1 day
(41 Reviews)
5.4
mhfsha

Hello Sir/Madam Ready to start now. I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task.I have 8 years experience of merge spreadsheet viru More

£20 GBP in 1 day
(100 Reviews)
5.3
(15 Reviews)
3.9
(15 Reviews)
3.9
varimaxanalytic

Hello! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can compl More

£14 GBP in 1 day
(2 Reviews)
3.5
chwaqas5434

Hello Sir! I am able to extract company names from all excel files and enter into an excel sheet with proper formatting, columns, and accuracy. I will complete this job in your given time period. I have Great Experien More

£13 GBP in 1 day
(18 Reviews)
3.6
(4 Reviews)
3.5
(10 Reviews)
3.3
EmiliaSimon

Hello, I have seen your requirements, and I am ready to help you extract certain data from a directory and combine it in one spreadsheet. I am a Data Analyst experienced in managing complex spreadsheets and VBA, and I More

£15 GBP in 1 day
(7 Reviews)
2.5
mishanth1988

I have understanding your project, I am ready work now this project. I can deliver the project within 4 Hrs because Freelancer is my full time Job, i can able to spend sufficient time to my client project. Already I ha More

£10 GBP in 2 days
(1 Review)
1.8
enywindows

Hello client, I have read your project and I understand your want to extract company names from different spreadsheets into one spreadsheet and i am confident in achieving this result in less time. I am an expert in ex More

£15 GBP in 1 day
(1 Review)
2.0
(4 Reviews)
1.4
petermainah

Hello there, I saw you posted this project yesterday about scraping fortune 500 companies from 1995 to date. I can see you have all the files now. Please allow me to merge the files for you. I am available and I will More

£15 GBP in 3 days
(1 Review)
1.4
manitakon

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.

£13 GBP in 1 day
(1 Review)
0.8