Grouping in Excel

Copper Contributor

Hello Everyone,

 

I a working on a PivotTable with age range in rows and sex in columns. When I group the age into the specific age brackets I want it automatically lumps blank cells into one of the age brackets. Anyone know how to prevent this from occurring?

 

Thank you!

0 Replies