Pivot Table - How to Add Formula to Exclude Row if a Cell is Blank

There are two ways to do this. Use the filter built into the pivot table to "turn off" (blank). The problem with this is the way pivot table filters work.

If you have (All) selected as a filter and a new item comes into the source data, Excel assumes you want to show the new item.

If you have any item unselected, then when a new item comes into the source data, Excel assumes you do not want to show the item. So new items are untracked unless you look for them manually and turn them on.

The other way of doing this is to use a helper column in the source data with the formula =ISBLANK(A2). This will evaluate to true if the ID is blank and false otherwise. You can use this new column as a report filter in the pivot table.