Consolidating three Excel files into One single master file

Search more jobs
Posted
Worldwide
I have three Excel files (GST2A, GST2B and GST Input). I want to create a master file using these three files with only unique values. This Master file should be in a specific format (which I will share).
First, we need to clean up GST2A file. Need to remove the blanks and duplicates and then use this file and GST 2B and GST input file to create a master file with only unique values

And as an add on, I want a mini excel dashboard that shows me the values from Master file and indicate which files this value exists in. For example, if master file has Value "XXXYYY", i need to know whether this value exists in all three files or just two or just one. Attached the three files.
I need this project to be done in a week.
  • $50.00
    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type

Skills and Expertise

Data Entry Skills
Computer Skills Communications
Data Entry Tools
Microsoft Office
Other
Microsoft Excel Data Entry Visual Basic for Applications Spreadsheet Software Data Scraping Accuracy Verification Graphic Design
+ 5 more

Activity on this job

  • 50+
    Proposals
    50+
  • 4 days ago
    Last viewed by client
    4 days ago
  • 6
    Interviewing
    6
  • 4
    Invites sent
    4
  • 1
    Unanswered invites
    1

About the client

Member since Jul 17, 2021
  • India
    Visakhapatnam 6:31 pm
  • 2 jobs posted
    100% hire rate, 1 open job
  • $124 total spent
    2 hires, 0 active
  • Member since Jul 17, 2021

Explore similar jobs on Upwork

Data Entry Copying UP
New
Hourly ‐ Posted 4 minutes ago
Data Entry Microsoft Word Product Listings Microsoft Excel Google Docs Daily Deposits Error Detection Clerical Procedures Researcher Virtual Assistant
Data Entry Copying UP
New
Hourly ‐ Posted 5 minutes ago
Data Entry Microsoft Word Product Listings Microsoft Excel Google Docs Daily Deposits Error Detection Clerical Procedures Researcher Virtual Assistant

How it works

Post a job icon
Create your free profile

Highlight your skills and experience, show your portfolio, and set your ideal pay rate.

Talent comes to you icon
Work the way you want

Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.

Payment simplified icon
Get paid securely

From contract to payment, we help you work safely and get paid securely.

Want to get started?

About Upwork

Stars rating
4.9/5
(Average rating of clients by professionals)
G2 2021
#1 freelance platform
49,000+
Signed contract every week
$2.3B
Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by
Microsoft Logo Airbnb Logo Bissell Logo GoDaddy Logo