Here is the sample file: https://www.codybaldwin.com/sample-file-pivot. Interested in learning more. You can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": https://www.codybaldwin.com/excel-course. Learn pivot tables in 6 minutes... Pivot tables allow you to automatically summarizes your data... so you can “slice-and-dice” in a million ways. This means you can replace lots of hand-typed summary calculations with more automated reporting. To create a pivot table, select a cell in your table and click “PivotTable” on the “Insert” tab.