How to combine similiar rows

I have the following table

Area	           Division	Q1	Q2	Q3	Q4
Outside	       001   3434	10	20	30	30
Inside	       001   5555	0	0	0	0
Around	       001   5555	1	0	4	3
Around	       001   5555	1	3	6	1

Sorry about the formatting "001 3434" is one division
I am trying to combine the unique combinations of Area + Division
So the resulting table would be:

Area	           Division	Q1	Q2	Q3	Q4
Outside	       001   3434	10	20	30	30
Inside	       001   5555	0	0	0	0
Around	       001   5555	2	3	10	4

Notice how before there were 2 lines with the same combination of Around and "001 5555". The new table has this line combined and the quarters of data summed.


I was wondering if anyone could help me accomplish this (in terms of a macro, unless there is an easier way, subtotals doesnt work well because I would still have to manually input a lot of data) as it will greatly help me overcome some obstacles in a larger project