In Excel, if you’re looking for a way to cross-reference your data, try exploring the recommended PivotTables for inspiration.

Excel suggests pivot tables for you.

From your data, click Insert, and then click Recommended PivotTables.

Excel suggests Pivot Tables based on your data.

Choose the one that best suits what you want to communicate.

You can choose to had the PivotTable in a new sheet or in an existing sheet.

If you choose existing sheet, you must specify in wich cell it will begin.