Pivot tables have a built-in feature to allow manual grouping.

Notice these groupsdo not appearanywhere in the source data.

Fields

The source data contains three fields:Date,Sales, andColor.

Pivot table group by custom - field list

The control key must be held down to allow non-contiguous selections.

The final two groups are named “Original” and “New”.

Excel will name the grouping field “Color2”.

Pivot table group by custom - field list

Pivot table group by custom - field list

Pivot table group by custom - field list

Pivot table group by custom - field list

Pivot table group by custom - original pivot table

Select cells, then right-click and select Group

Grouping field renamed from “Color2” to “Group”

Grouping field set to insert blank line

Grouping field renamed from “Color2” to “Group”