Excel 2013 and above has the ability to analyze the data, and recommend the most suitable pivot tables for it.
To use this feature, locate the cursor in a cell in your data table, and under the “INSERT” tab, click
Excel will suggest a list of pivot tables:
Select the one that suits your needs.