MasterSheet Merging/Deduplicating Excel Sheets
$30-250 USD
Betalades vid leverans
I have 227 Excel files in ".XLSX" format. I need them all merged and deduplicated then added to a workbook we'll call MasterSheet.XLSX. I need them to be deduplicated by Column C which always has a domain "[login to view URL]" each domain is a link from a website called AIH from which the data was scraped and each domain is a link to a different company. I anticipate perhaps 600,000 total companies after deduplicating.
I need to combine this data into one file and deduplicate it by company using the link in Column C as the unique identifier. I also would like to add columns as many will be in, perhaps 9 categories. THE CATEGORY IS IN COLUMN A. I need that info on the Master Sheet so if we could add perhaps 8 columns and add every Category from Column A as a different column. So let's call them C1,C2,C3,C4,C5,C6,C7, and C8. Like...If Company ABC shows up first as a company under the "Electric" Category by Column A on the first search...we add "Electric" to C1. If he's found on a second file with "Exploration" as the category in Column A, we then add "Exploration" to C2 on the Master Sheet. The next time we add it to C3.
An example sheet is attached . Rest pon Drive link..
FILES LOCATED ON GOOGLE DRIVE AT:
[login to view URL]
Projekt-id: #36489688
About the project
87 frilansare har lagt bud på i genomsnitt $140 för det här jobbet
Greetings, As a highly skilled Excel specialist with 10 years of experience, I am confident in my ability to complete the Excel job you have to perfection. I have expertise in the following areas: - Formulas and fu Mer
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Mer
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, I am Senior Python script developer with 10 years of experience. I can 227 Excel files into one masterfile by python script/bot with your instructions very short time. Can we discuss please? Thanks.
Hi Joseph, I'll be glad to assist you with this. I can merge data from 227 excel files and deduplicate into Mastersheet, the add categories column. Let's chat so we can go through more specifics. Thanks for your ki Mer
Hello there! My name is Akriti and I'm an Excel VBA programmer with more than 5 years of experience working with this software. I understand you're looking for someone to merge/deduplicate 227 Excel files and add them Mer
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within some hours
Sure. I have to ask some questions regarding project? Let me know your interest for the same. I am ready to create sample and start right now. Thanks.
Hello Joseph, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right ski Mer
Hi, I am an Excel, Power Query, VBA, & Power BI expert. I can easily merge all the files in one go based on certain criteria we want to implement. I have done this numerous times, in fact I do similar tasks on regular Mer
I understand you are looking for someone to merge and deduplicate 227 Excel files and add them to a workbook called MasterSheet.XLSX. You need them all merged and deduplicated by column C which always has a domain name Mer
Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot table Mer
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from Mer
Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Mer
With over 7 years of experience in excel usage and an ACCA qualification, I have expertise in all areas of Excel, I can provide you with efficient, accurate, and insightful solutions to your data-related challenges. My Mer
Hi there, Thanks for this project. i always like to work on excel. good in data cleansing and making Mastersheet from different sheets. I can follow your instruction and get you the result soon. Thanks