I created a pivot table and I want to show the blank cells as well as those with data. but the problem is that it is being listed as the last entry on the column. is there a way i can make it move to the top of the column without changing the way other data is recorded?