clean up a messy excel sheet

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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

Обробка даних Excel

ID Проекту: #6413408

Про проект

5 заявок(-ки) Дистанційний проект Остання активність Sep 4, 2014

Доручено:

newhightech

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 Більше

$35 USD за 3 дні(-в)
(0 відгуків(-и))
0.0

5 фрілансерів(-и) готові виконати цю роботу у середньому за $30

hdlong66

Hello. I've read your project description and your templates. I am able to do it quickly for you. Would you share your file, please? Kindly refer to my related projects: https://www.freelancer.com/projects/Data-Entry Більше

$40 USD за 1 день
(26 відгуків(и))
4.2
Ibrahim33

Hello Mr I am an experienced engineer, Professional English-Arabic translator, web designer , creative Arabic writer, Communication Specialist , web Research and data entry . My working skills High research Більше

$30 USD за 1 день
(4 відгуків(и))
2.4
kher78

Give me a shot! As you will see I'm a new freelancer with a lot to prove. Let me prove my worth to you at risk...if I can't turn this within a day and get it back to you then you don't accept my bid. If I do then I Більше

$15 USD за 0 дні(-в)
(1 відгук)
1.0
julianmartinez90

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 Більше

$30 USD за 1 день
(1 відгук)
0.4