Description of excel work: Hi there,
We are in the process of undertaking a CRM implementation project. We have been provided with a number of data exports in MS Excel from our client. Two files in particular need 'merging' together prior to importing. Both MS Excel files contain 'basic' company information - one, a list of Companies with their addresses and contact details; the second, a list of Employees associated with the Companies, the Company name, plus the direct contact information for the employees. There is in some instances multiple employees per company. We need the 'Employee' spreadsheet 'transposed' against the 'Company' spreadsheet, row by row so:
- Company Spreadsheet contains on one row, all Company Information spread across the columns, followed by all the associated Employee data, spread across the columns.
The only data to match on are the 'Company Names' - we 'may' be able to include a 'Company Ref' as a URN.
There are approx 2k records per file.
Brooke R.100% (8)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Sounds great! I have some questions
This looks like a fun, and pretty straightforward project. Just to be sure I've understood your brief, could you clarify exactly what format you want the output to come in?
If I understand correctly, you need 1 record per employee, each record to also contain the company information. Is that correct?
Hi Brooke, Can you provide "URN" reference number along with company names..May be it can make this project much easier..Thanks.
Good Evening Brooke,
Could I see some sample data from each file please.
Able to share sample files with 1 or 2 records?