Well, you can click on the ⊟
to the left of “Banana”, “California”, and “Spain” to collapse the subordinate rows:
But of course you don’t want to do that manually. You can automate it with VBA: select the first column of the pivot table and run this code:
For Each c In Selection If c.Value = "(blank)" Then c.Offset(-1, 0).ShowDetail = False End If Next c
If you don’t know how to use VBA, see How do I add VBA in Microsoft Office?