Filter some data on excel to take out double ups

$10-30 USD

In Progress

Posted

almost 5 years ago

$10-30 USD

Paid on delivery

I have a data analysis task. We need to sort out the contact details contained in several databases for the USA, Australia and Canada. These are contained in Excel documents. There are approximately 19000 USA entries between 6 documents (7500, 11000, 28, 180, 150, 120) I think . Each of these documents is currently formatted differently so the information is in different columns and they are in different stages of completion. · We need to combine these lists into a master list with all the information in matching columns. · We need to eliminate multiples of the same businesses that have the same email address. · Create 3 pages within the document. One with all the unique listings, one that has email addresses for all listings, and one that has mailing or physical addresses for each listing. · The Canadian lists are contained within the USA documents and need to be separated out into a Canada list document. In Australia we have about 7000 listings over 5 documents and we need to do exactly the same with those as for the USA lists. I also need the contacts pulled from all customers in USA and canda [login to view URL]

Business Analysis

Project ID: 20337560

About the project

4 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@pjlnel

Dear Sir or Madam, I am a South African based professional Accountant with a proven track record. My qualifications include a post graduate degree in Management Accountant with my main subjects: Cost Accounting Advanced Decision Making Techniques Enterprise Management Management Accounting Strategic Management Financial Reporting Financial Analysis I have over 20 years of work experience, ranging from accountant to CFO level. Some of my exposure and experience includes: Full Accounting Responsibility (Cashbooks, AR, AP, Management Accountants) Preparation of Annual Financial Statements HR and Payroll Financial and Risk Analysis Cashflow management Medium to Longterm Budgets Cost Accounting and Variance analysis Liaison with company auditors and preparation of the audit files I am an advanced Microsoft Office user with above average software skills. I am have read your project requirement and I am capable of completing the project on time. If you require any additional information, kindly contact me. Regards Phillip

$30 USD in 2 days

5.0

(1 review)

1.0

4 freelancers are bidding on average $36 USD for this job

@naimagul

Hi, I am an expert in Excel having vast data analysis experience using spreadsheets. I am proposing my services for the task. Let's talk about the project a bit more. Please message me. You have mentioned that data is in Excel but you are asking to create the document. I hope you are meant by 'sheets'. Please note I'm new on this platform, so I am proposing my services in a discounted rates. This way I also want to build a trust with you. Hoping to hear from you.

$25 USD in 4 days