Denormalise Excel data
- or -
Post a project like this2149
$$
- Posted:
- Proposals: 17
- Remote
- #1997068
- Awarded
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
Manual Data Collection from Google/B2B Lead Generation/Web Research/Data Entry/Data Mining/Data Gathering
Mumbai
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
1267140122469011046301075464745411
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