
Abgeschlossen
Veröffentlicht
Bezahlt bei Lieferung
I have two spreadsheets—“Vendor Master Data” and “Vendor Contacts”—that need to be merged into a single, clean file. The tricky part is that many company names are spelled slightly differently between the two sources (but they are easily recognisable which company refers to which), so a simple VLOOKUP falls short. I’d like you to tackle the match using a blend of fuzzy-matching functions and hands-on cleanup. I don’t have a fixed tool in mind for the automated pass, so feel free to choose the approach you trust most. After the function/algoritham does its work, I expect a manual review to catch anything the software misses. You’ll see 10–12 sample rows already formatted exactly how I want the final output to look in 'Vendor Master Data' spreadsheet; use these as your template. When you return the finished file, every vendor should appear once, with the relevant contact info correctly aligned in the same row. Deliverables • One consolidated Excel workbook matching the provided format • Clear indication (e.g., a separate tab or simple comments) of any records that required manual judgment because no reasonable automated match was found Let me know if this fits your skill set and roughly how many hours you’ll need.
Projekt-ID: 40214165
12 Vorschläge
Remote Projekt
Aktiv vor 1 Monat
Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten

Hi there, I am clear with the instruction , ready to get the data of merged details of both the excel... i will update details for 140 company details from vendor list and then make balance available data in mastersheet perfectly. waiting to accept the project. Thanks
₹800 INR in 1 Tag
5,6
5,6
12 Freelancer bieten im Durchschnitt ₹1.013 INR für diesen Auftrag

I’ve carefully reviewed the job description and am ready to get started right away. I’d love the opportunity to discuss the details further to ensure I fully understand your requirements and expectations. Please feel free to send me a message so we can talk more about the project.
₹600 INR in 7 Tagen
3,2
3,2

Hello, I can merge your “Vendor Master Data” and “Vendor Contacts” spreadsheets into a single clean, consolidated file using fuzzy-matching techniques combined with careful manual review to ensure accuracy. I’ll apply reliable matching logic to handle name variations, then cross-check results against your sample rows so every vendor appears once with the correct contact details aligned. Any uncertain matches will be clearly flagged in a separate tab or with comments for transparency. You’ll receive a final Excel workbook that matches your format exactly, along with notes on records requiring manual judgment. Happy to review the files and estimate hours once shared.
₹900 INR in 6 Tagen
0,0
0,0

I will complete this project ASAP , working in Excel from last 4 years , i ensure you that I will give my best for this project
₹1.050 INR in 7 Tagen
0,0
0,0

Hello, I can merge your Vendor Master Data and Vendor Contacts into one clean Excel file. Since vendor names differ slightly, I’ll use Excel Macros with fuzzy matching logic, followed by manual review to ensure accurate matching. I’ll also follow the provided sample rows as the final output format. Deliverables: One consolidated Excel workbook Separate indication for records needing manual review Looking forward to working with you. Jayasri
₹700 INR in 7 Tagen
0,0
0,0

I can confidently handle this task. I’ll merge both spreadsheets using fuzzy matching to align vendor names, then manually review and clean any unclear matches. You’ll receive one consolidated Excel file in your required format, plus a separate tab noting any records that needed manual judgment. Estimated effort: 4–6 hours.
₹1.000 INR in 7 Tagen
0,0
0,0

I have worked with multiple data projects and cleansing of data, I think I can complete the project within the given timeline using my skills
₹1.050 INR in 10 Tagen
0,0
0,0

Hello, I will merge both Excel sheets using software. Please give me a chance, and if you need similar work in the future, I’ll be happy to help. This task can be completed accurately and on time.
₹3.000 INR in 7 Tagen
0,0
0,0

Hello, I can help merge and clean your Excel vendor data quickly and accurately. I have experience consolidating multiple files, removing duplicates, and standardizing vendor information using Excel formulas and tools. I’m ready to start immediately and deliver a well-organized master file. Best regards, Barsatoo Yadav
₹600 INR in 5 Tagen
0,0
0,0

Hello, I’d be happy to help merge your “Vendor Master Data” and “Vendor Contacts” spreadsheets into a single, clean, consolidated file. I have experience in Excel, VBA, data cleansing, and data integration, including handling cases where company names are slightly different and require fuzzy matching combined with hands-on review. I can use trusted techniques and formulas to perform an automated match first, then manually review any ambiguous records to ensure accuracy. I’ll follow the sample rows you’ve provided to make sure the final output matches your required format exactly. I will also include a separate tab or comments to highlight any records that required manual judgment, so you have full transparency. My approach ensures every vendor appears once, with contact information correctly aligned. Based on the project scope, I estimate it will take 4–6 hours to complete, depending on the total number of vendors, and I can start immediately. Accuracy, attention to detail, and a clean final file are my priorities. Looking forward to helping you streamline this data effectively. Best regards, Aamish
₹800 INR in 2 Tagen
0,0
0,0

Saya akan semaksimal mungkin berkerja semampu saya ,tidak akan mengecewakan klain , Klain akan puas apa yg saya kerjakan
₹1.050 INR in 7 Tagen
0,0
0,0

Gurugram, India
Zahlungsmethode verifiziert
Mitglied seit Sept. 28, 2025
₹1500-12500 INR
$30-250 USD
$250-750 USD
$10-30 CAD
$14-35 USD
$30-250 USD
₹12500-37500 INR
$10-30 USD
$10-30 AUD
£10-20 GBP
₹600-1500 INR
₹600-1500 INR
₹1500-12500 INR
$50-100 USD / Stunde
$250-750 USD
₹750-1250 INR / Stunde
$30-250 USD
₹12500-37500 INR
$15-25 USD / Stunde
₹1500-12500 INR
$50-75 CAD