![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Advanced Microsoft Excel skills Needed for Data Merging and De-Duplication
- or -
Post a project like this2288
$$$
- Posted:
- Proposals: 18
- Remote
- #1948147
- Awarded
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
20 plus years of exposure of assisting its clients in Financial Modelling, Company valuations for Fund Raising in various stages of FR life cycle.
13718277539391946714122469011927982140087208270150008320569891314007
![Ash G.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/efa84c850525bd6b57ca2a1c8bfc8954_70x70.jpg)
![Safdar K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/88bcdac0774a11803d97a0ac767b6c3e_70x70.jpg)
![Md. Ariful I.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/b824839a33cb014584e3dd63b789c1e0_70x70.jpg)
![Rahim A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/52db0109356dcaf2d500d6f3b7e092e6_70x70.png)
![Genadiy R.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/9241acddeccbc8303f6ce74782798368_70x70.jpg)
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.](https://www.peopleperhour.com/imgs/default_avatar_light_70x70.png)
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