Excel data anlysis - repost

CANCELLED
Bids
19
Avg Bid (INR)
4816
Project Budget (INR)
₹1500 - ₹12500

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:
Copy Typing, Data Entry, Data Processing, Excel, Word
About the employer:
Verified
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.


₹ 1500
in 1 days
Hire chrisiew89
₹ 1500
in 2 days
₹ 5000
in 3 days
₹ 12000
in 4 days
₹ 2000
in 4 days
₹ 3000
in 1 days
Hire unwanted
₹ 5000
in 5 days
Hire pappysimha
₹ 5000
in 2 days
Hire props21
₹ 7000
in 8 days
₹ 3500
in 8 days