Forum Discussion

nlabell127's avatar
nlabell127
Copper Contributor
Apr 14, 2020

Grouping in Excel

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!

No RepliesBe the first to reply