Create a macro for Excel.
Create a macro for Excel that automatically process the data on the raw sheet, and input all the information in the output sheet. The macro will do all the counting and grouping. All I should have to do is click a button.
Please see the attachment.