Modify excel spreadsheet data

Modify excel spreadsheet data

Closed - This job posting has been filled and work has been completed.

Job Description

I need a person who is an expert in Microsoft Excel who is able to create a script so that data in a excel spreadsheet can be automatically modified into a more usable format.

I have attached an excel file for review. The first 10 sheets of the file is how the current data is formatted. Sheet 11 (named "Example") is an example of how I need the data to be formatted.

Instructions:

1- The original file has individual contact information on 2 separate rows. I need all of the information to be on 1 row.

2- The first file has the first and last name in one cell. I would like to have the first and last name separated into two separate cells.

3- The first file has information that I do not need. I have named column headers in the 2nd file of the information that I need.

4- File 1 has 1000 contacts that are spread across 10 sheets. I need all of the contacts to be on 1 sheet.

5- The final file will have approximately 10,600 contacts. Therefore, I will not consider any application to modify this data manually.

Please follow these instructions to apply.

1- Please review the attached file and let me know if you have the skills to modify the data as outlined in the instructions.

2- Please provide a brief explanation on how you will complete this job.

3- Please provide an estimated time of when you would be able to start and how many hours it would take you to complete this job.

4- When applying for this job, please input "Edit Contact List" on the first line of your application. This is to ensure that all applicants have read the job description. Any application received without this phrase on the first line will not be reviewed or considered.

Open Attachment