Don't leave repeated values blank in a pivot table field?

Hi ThomasCarter,

I believe within a pivot table in Excel versions below 2010, the answer is no.

I would say the only way to achieve what you desire would be through VBA.