Question: have pivot table ignore blanks?
Answer: Click on the arrow to the right of the Order ID drop down box and un-select the checkbox next to the blank value. Then click on the OK button. Now whenever the Order ID is blank, that data will not appear in the pivot table. It will be hidden.