Validate and combine 2 excel spread sheets into one sheet

This project was awarded to Engineer85 for $30 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 AUD
Total Bids
Project Description


I need two separate spreadsheets cross checked and combined to create a validated master spreadsheet of australian private a public hospitals.

Spreadsheet 1 - this is a yellow pages scrape with duplicates and errors

Spreadsheet 2 - this is a scrape from another source.

Combine, validate, remove duplicates and split data into separate data fields.

Type: (Private or Public)
Hospital Name
Address 1
Address 2
Post Code

It must be in excel format in one list, one sheet.

Files to follow.

There are 580 private hospitals in Australia and 750 public hospitals. I am trying to get a complete and accurate list of all of them for inclusion into an ios app.

Thanks for bidding.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online