I am creating a pivot table from hierarchical flattened raw data. The (blank) gets inserted into the pivot table whenever there is a blank row cell in raw data. Is there a way in VSTO workbook through which this blanks on pivot tables can be hidden or deleted?
