Do you have Power Query (Get & Transform on the Data ribbon) in your version of Excel? If so, your summary table can be created easily.