Excel data anlysis - repost

This project received 19 bids from talented freelancers with an average bid price of ₹4816 INR.

Get free quotes for a project like this
Project Budget
₹1500 - ₹12500 INR
Total Bids
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online