Advanced Microsoft Excel skills Needed for Data Merging and De-Duplication
- or -
Post a project like this2188
$$$
- Posted:
- Proposals: 18
- Remote
- #1948147
- Awarded
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
199199915000832153673214008720569891946714164249235495
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