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
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
or discussion and wish you a great day.
Please See my portfolio,
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-Excel/Copy-spreadsheet-schedule-found-another.html
https://www.freelancer.com/projects/Data-Analysis-Conditional-formatting.html
https://www.freelancer.com/projects/Merge-Spreadsheets.html
https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Spreadsheets-into-one-that.html
https://www.freelancer.com/projects/Excel-Data-Processing/some-Excel-Work.6080256.html
https://www.freelancer.com/projects/Enhance-Spreadsheet.html
https://www.freelancer.com/projects/Excel/Write-some-Software.5960899.html
Wait for your response.
Thank you and Best regards,
Hoang
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 capability.
Ability to work under pressure.
Open minded to new ideas and new technologies.
Self-learning ability.
I've the ability to work in different fields, even new fields where I gain my knowledge so fast through reading and research.
Be sure your work will be done in perfect way and perfect time.
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 would kindly ask that you accept my bid and provide me with a positive review. I think you will find my proposed price attractive :) Look forward to turning this spreadsheet around for you! I stand by waiting.
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 really make it out. Let me know.