Hi all,

Using Excel 2010
How can I hide Row Labels with "(Blank)" but keep visible all Column Fields (Jan - Dec) whether they contain values or not?

When I filter out (blank) in the Row Label, all out months are hidden from view as well.

I added 0 values to the data source for out months for a known row label in Jan/Feb - but there must be a better way

thx
w