Excel data anlysis

Avg Bid (AUD)
Project Budget (AUD)
$30 - $250

Project Description:
I have data on approximately 200 groups over 40 years. I have the data on 40 different excel sheets, and each spreadsheet lists all the groups for that particular year.

I want to know how these groups are changing over time in one specific criteria. The criteria is in a single column on each sheet.

The list groups do change slightly from year to year, as occasionally groups did not submit data.

So to analyse the criteria you must carefully cut and paste the columns from 40 sheets into one big sheet. There will probably be just over 200 rows, one for each group. There will be 40 columns, one for each year.

But you must be careful to make sure the right number goes in the right box, because the rows are not exactly the same each year. You cannot do a simple 'cut and paste'.

I have done the first four years as an example.

If this project goes well, and i have enough money, I will post two other projects looking at two other criteria

Skills required:
Data Entry, Data Processing, Excel
Additional Files: QB+year+on+year.xlsx
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 400
in 5 days
$ 95
in 2 days
$ 140
in 3 days
$ 200
in 5 days
$ 75
in 7 days
$ 45
in 2 days
$ 90
in 3 days
$ 55
in 1 days
Hire nagybatonyi
$ 100
in 4 days
Hire mrbrave
$ 50
in 1 days