Project Detail
Data Combining - Create 1 Excel Sheet From Many Sheets
Data Combining - Create 1 Excel Sheet From Many Sheets is project number 361735
posted at Freelancer.com. Click here to post your own project.
Bid Count: 24
Average Bid:
$ 55
12/29/2008 at 16:30 EST
Project Creator:
jhou82
Employer Rating: 
(15 reviews)
Description
I have an xlsx file that has about 80 workbooks inside it. Each workbook represents a category and has only one column in it with a unique ID in it.I need a single workbook created with a column for the identifier and then 80 more columns with a 1 or 0 in it if that identifier appears under a given category. So this is how the process would work for 1 category:
1) Open Master File which will already have about 300,000 rows in it
2) Copy all rows from category 1 into bottom of master file
3) Use CountIf function or other to identify records that appear under this category
4) Repeat for all categories.
The files used in the example would be 2:
1) Master File With This Layout:
Attorney Cat1 Cat2 Cat3.....80
--------- ----- ---- ----
AttID1 1 0 0
AttID2 0 1 1
AttID3 1 1 1
2) Cat1 File
Attorney
----------
AttID1
AttID3
After all processing is complete I need any duplicate rows to be removed.
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results