So here's my questions:
I have a pivot table (Excel 2007), simple enough, rows = Age of a person, columns = series of traits.
Now, in doing up annual reports, I want them all to look the same, so the Age rows range from 0 - 24. Problem: in any given year, my data set does not include all ages from 1 to 24, so the pivot table has gaps:
Age
0
1
2
4
7
8
9...
How do I fill in these gaps (i.e. add a row "3", "5", "6", etc.) to show blank rows, when they don't exist in the data set?
I hope this makes sense, thanks for any insight anyone can offer.
Bookmarks