Advanced Microsoft Excel skills Needed for Data Merging and De-Duplication
- or -
Post a project like this2201
$$$
- Posted:
- Proposals: 18
- Remote
- #1948147
- Awarded
20 plus years of exposure of assisting its clients in Financial Modelling, Company valuations for Fund Raising in various stages of FR life cycle.
New Delhi
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Husband & Wife Team - Software Engineer, Public Relations Guru & Graphics Designer
Ypsilanti
1371827131400712246901192798905854768831753939716799361675208270
Description
Experience Level: Expert
We require an expert in Excel who can take 2 sources of csv(excel) data and bring them together as one.
We have a Sales database with customer information such as Name, Contact, email, address, custom fields. We have a separate Accounts database with customer information such as Name, Contact, email and other accounting fields.
We need an expert to take these 2 sources and bring them together into 1 excel sheet so that we have one Company record with some fields from the Sales database and some fields from the Accounts database. Where there is duplication we need to choose one of the fields (based on some logic or other).
The sales database has multiple rows for one client and we also need this to be transposed into columns as part of this process so we just have one row per client with many columns.
Please see example CSV from each of the 2 database sources.
Many thanks
Ian
We have a Sales database with customer information such as Name, Contact, email, address, custom fields. We have a separate Accounts database with customer information such as Name, Contact, email and other accounting fields.
We need an expert to take these 2 sources and bring them together into 1 excel sheet so that we have one Company record with some fields from the Sales database and some fields from the Accounts database. Where there is duplication we need to choose one of the fields (based on some logic or other).
The sales database has multiple rows for one client and we also need this to be transposed into columns as part of this process so we just have one row per client with many columns.
Please see example CSV from each of the 2 database sources.
Many thanks
Ian
Ian G.
100% (43)Projects Completed
56
Freelancers worked with
44
Projects awarded
17%
Last project
19 Oct 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies