clean up a messy excel sheet

Help me extract data from a sloppy, poorly-organized spreadsheet. Re-format the data into a nice, clean sheet. This is a BIG set of data, you’ll need to write a script, or use other automatic means to process it. Doing it by hand would be very tedious. Specifically: - Currently, data from 3 separate teams are side-by-side in "super columns" (separated by black bars) - Remove the totals and averages that are at the bottom of each "super column" - Combine these into one set of columns, adding a column called "team name" - Remove all the blank lines - Label “agent name” on each record (currently they are separated by colored bars, with the name listed on the first one) - Combine data from separate sheets together into one sheet. Add columns for “month”, and “year” (found in sheet name) See “sample [login to view URL]” and “sample [login to view URL]” to see what I want. To get the job, tell me how you will accomplish this. After selecting a worker, I will send the real data file in XLS or ODS format