Denormalise Excel data
- or -
Post a project like this2162
$$
- Posted:
- Proposals: 17
- Remote
- #1997068
- Awarded
Graphic Designer|Web Developer|Writer|SEO|PHP|Copywriter|Template Modification|WordPress|Custom Website|
Bahawalpur
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
14488012208807220737022073092193531216616918894541829301178829015980813718271300449
Description
Experience Level: Intermediate
Hi
We have data in a spreadsheet with company details and employee contact details. After the first row for the company there is an additional row with the employee contact details in columns. This means that the company has multiple rows depending on how many contacts there are.
For an import to another system, we need a file with one row for each company and an extra column created which concatenates all the contact fields into one field.
Ie individual fields for additional contacts name, role, email, address etc are all one field "nameroleemail<br/..." etc.
Example shows row data to be concatenated into additional fields so there is one data row per company.
Thanks
We have data in a spreadsheet with company details and employee contact details. After the first row for the company there is an additional row with the employee contact details in columns. This means that the company has multiple rows depending on how many contacts there are.
For an import to another system, we need a file with one row for each company and an extra column created which concatenates all the contact fields into one field.
Ie individual fields for additional contacts name, role, email, address etc are all one field "nameroleemail<br/..." etc.
Example shows row data to be concatenated into additional fields so there is one data row per company.
Thanks
Graham M.
100% (14)Projects Completed
17
Freelancers worked with
12
Projects awarded
57%
Last project
23 Dec 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
hello
sir, i want to know how many data?
636587
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