Some times you need something more quicker than pivot table and your results to be more visual. This macro is a solution.
Press Ctrl+Q after opening the file. You need to have your macros enabled. else rerun the file and click on “enable macro”.
Download the excel file from here.