Complicated removal of duplicates in excel

I have a complicated situation here on removing duplicates.
Let me explain as detailed as possible here.
Attached is a file I'm attempting to submit.
Column A is a census tract number
Column B either has a 1 or a 0 indicating a service type
Column C has number of circuits
Column D has number of circuits that fit a specific description.  

When I submit this file it looks as though there is an issue with duplicate census tract numbers...which is very possible considering one "customer" at the same census tract can have multiple services and multiple circuits at each respectively.  

What I need is a method of combining data to remove duplicates in column A.  

My results need to be as follows: (I will provide examples as best i can to help you follow my line of thinking)
1)  I need to separate this file into 2 separate files based off of Column B - all of the 0's in one file/sheet and all of the 1's in another. (this is easy enough to do, but i did not move anything so you could see the entire issue at hand)
2) For all census tract numbers in Column A that also match in Column B, I need the number of circuits combined.  For example Cell A104 has the same census tract as Cell A 105, and they both of 0 in Column B.  These would need combined and then their value in Column C would need added together.  So it would look like this 21193971000,0,2,0  
3) Once their circuit values or Column C values have been combined all duplicate census tracts would then need removed so there is only one census tract.
4) The same would need done to all items that have a Column B value of 1.

Can you help please?
2014-U4-477-filing.csv
binaryman101Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aikimarkCommented:
what about column D?
0
tilsantCommented:
Hi,

Assuming even values from column D needs to be summed up, PFA a solution which uses basic functionality of a Pivot Table (using Classic layout). You can filter for service type 0 or 1, from column B.

Let me know if this works for you.
Filing.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
binaryman101Author Commented:
That will give me what I need.  Thank you very much.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.