ymze

a pivottable will always show a row/column combination if it is *non
emtpy/null* for at least *one* of it's row/column combinations.
Indeed, if you are unlucky each data row/column will only have a
minimum of 1 non null item.

DM Unseen