Good day, all-

See the attached image.  I'd like to have no row where it shows as blank.  But if I filter to exclude blanks, I only show the one row for 'other'.

Any ideas how I can achieve this?

• Moved by Edward ZMicrosoft contingent staff 1 hour 8 minutes ago excel product

Hi Casey_M,

This forum is for Developer discussions and questions involving Microsoft Excel, your issue is more related with excel pivot table product feature, I will move this thread to the more related forum.

Reference: http://social.technet.microsoft.com/Forums/en-US/home?forum=excel

In addition, your image is too small to see, it would be better to share us a large image.

Thanks for your understanding.

Best Regards,

Edward