I'm trying to build what *should* be a simple pivot table with 2 fields and
having some difficulty.

The problem is that Excel wants to automatically aggregate like values. For
instance, the two fields are Product Family and Part Number. There are cases
where 2 different Product Families can share a Part Number (don't ask). In
these few instances, The pivot table wizard automatically groups the 2
instances and only lists the Part Number once; in the second instance, it
generates a blank cell where the PN should go. This wreaks havoc on one of
my macros that needs every single instance listed, ie, no empty cells.

I've gone over and over the pivot table settings and can't find a way to
flatten this or force Excel to understand I don't want these situations
aggregated in the first place. Can't find help on or offline either. Any
experts here have a suggestion?

Thanks,

Randall Arnold