Excel Spreadsheet Help - Data Reconciliation & Consolidation

Closed - This job posting has been filled and work has been completed.
Admin Support Data Entry Posted 3 years ago


Less than 30 hrs/week
Less than 1 week

Entry Level

Start Date

August 12, 2013


I have an Excel spreadsheet with roughly 9,000 rows and 29 columns of data.  There are a few ways in which I would like the data to be consolidated:

1. About 3000 rows have data supplemental which should be copied and pasted into the other rows, so that these 3000 rows can be deleted.  There is often no unique matching identifier, so this needs to be done manually (eye-balled), looking from one row to another to see if the data is regarding the same topic.

2. Many rows are redundant for all but 3 columns, which I would like to be merged/concatenated so that we can eliminate redundant rows.  For this, there are unique identifiers, so this can probably be done through a formula or macro.

The right candidate for this position will have great Microsoft Excel 2010 skills and either willingness to go through the spreadsheet manually for find an ingenious automated solution to perform 1 or both steps.

Confidentiality is very important for this project, so it will require an NDA.

About the Client

(5.00) 1 review

United States
Culver City 11:39 AM

4 Jobs Posted
75% Hire Rate, 1 Open Job

$186 Total Spent
3 Hires, 1 Active

$3.79/hr Avg Hourly Rate Paid
47 Hours

Member Since May 10, 2013