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.