PIVOT TABLE

Method #1 · Click a cell in the data worksheet · In the “Tables” section of the “Insert” tab, click “Pivot Table ” · A “Create Pivot Table”

4 How to create a pivot table in Excel · Step 1: Insert a pivot table · Step 2: Set an intention · Step 3: Create a summary · Step 4: Create a

table How to Create Entirely New Rows with a Pivot Table · type the name of the row in the name field · write the formula – in this case, “Assists

j league table Highlight the cells you want to turn into a pivot table If entire columns, highlight the entire column (blank cells that appear after the data