clean up a messy excel sheet
$10-40 USD
Оплачується при отриманні
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 [url removed, login to view]” and “sample [url removed, login to view]” 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
ID Проекту: #6413408
Про проект
Доручено:
I did the same project, by creating a Macro in Excel, to automating work if you wanna repeat the same work in the future. I can do this job for you in few time , I remain at your disposal for any remark, comment o Більше
5 фрілансерів(-и) готові виконати цю роботу у середньому за $30
Hi, i'm a organized freak so i really would like to put an order to your speadsheets. I would do it with great calm and try to make everything look nice a well. I already look at the sample files and i think i can real Більше