I need an MS Excel Expert
- or -
Post a project like this- Posted:
- Proposals: 38
- Remote
- #1546567
- Awarded
Description
Industry: Business
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.
Extra notes:
Brooke R.
100% (9)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Brooke,
Sounds great! I have some questions -
Hi Brooke,
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?
Kind regards
Catherine -
Hi Brooke, Can you provide "URN" reference number along with company names..May be it can make this project much easier..Thanks.
Regards,
Shikha Rastogi -
Good Evening Brooke,
Could I see some sample data from each file please.
Regards
Tony H -
Brooke
Able to share sample files with 1 or 2 records?