Closed

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
34
Project Description

Hi

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
Suburb
Post Code
Website
Email
Phone

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