Challenge 2: Grouping 200 Ages into 10-Year Bins — Solution Walkthrough

Steps:
  1. Right-click any value inside the Age field in the PivotTable's
     Rows area.
  2. Choose Group.
  3. In the Grouping dialog, set:
       Starting at: 0
       Ending at:   100
       By:          10
  4. Click OK.

Resulting Row labels:

  0-9
  10-19
  20-29
  30-39
  40-49
  50-59
  60-69
  70-79
  80-89
  90-100

Instead of 200 individual Row labels (one per unique age value found
in the data), the PivotTable now shows just 10 bins, each covering a
10-year span, with every person's individual data point rolled into
whichever bin their age falls into.

Explanation:

This is the exact same right-click → Group mechanism Excel
Fundamentals Chapter 9 introduced for dates, applied here to a
numeric field instead. The Starting at / Ending at / By settings
define the bin boundaries directly — By: 10 is what makes each bin
span exactly 10 years, and changing that single number to, say, 5
would instead produce 20 narrower bins covering 5 years each, without
touching anything else about the PivotTable's setup.

Notes:
- Any Values field placed alongside the grouped Age Rows (e.g. Count
  of Customers, or Average Spend) automatically re-aggregates per bin
  rather than per individual age — exactly the same "Rows determines
  the grouping, Values determines what's summarized for each group"
  relationship from Chapter 9's original four-area explanation.