To group like data together you want to sort your information first. This is going to be key. Using the Subtotal feature of Microsoft Excel you will be able to group the like data eg; State then perform a mathematical instruction like sum, Average or...