The project is to merge datasets. I have a master dataset of 5138 entities. This data includes business name, business address, longitude/latitude, etc. This is in text (tab delimited) format. Then, I have 51 files of 50-150 entries each that contain business name, address, longitude/latitude. These 51 files merged into one long file. I want the entity identifier from the master data set matched onto the entries on the second dataset. The names and addresses will match but not always textually exactly. (For example, the address in one might say 5158 S Windsor Dr and the address in the other might say 5158 South Windsor Dr).
Please specify how you would do this. By hand is one possibility, but you must have facility with US address/language conventions.
Most items can be matched by a series of refined matching formulas gradually decreasing the number of unmatched entries which shall be matched ba a final visual check. If you send me some sample files I'll do a pilot showing the concept. I'm good also in VBA programming, if it shall be necessary I'll be able to support the solution with macros.
Regards!
Hi,
This is not a problem I have done several such projects. Check my feedback and a reference in private message. I would set up multiple match criteria and then ultimately visual check. The result would be spot on.
Regards
David
Hi,
I have a good deal of experience in excel data processing. I can help with merging of the datasets and can start immediately.
Please check PMB
psprongs
Hello
I'm so interested in this job and I've taken my ICDL with a very good knowledge of EXCEL , for more informations I've sent my CV in PM
Thank you and hope to hear from you soon !
Dear Sir, We can very well understand your requirement and will be happy to get started with the work. Please Send your File. I am ready to start this work immediately. Please Try us once & you will be HAPPY that you have FOUND us. Thanks & Regards, Rathi
Hello,
I am new to freelancer, but this is a task I can do quickly and without error. I have expert level excel skills and a lot of experience with large sets of data. I will be following up with a personal message containing relevant experience. Thank you for your consideration.