Thanks! I didn't know about using Tables. That will come in handy.

Sorry I should have been more clear about why I want to update the source data. This pivot groups by dates and it won't let me do that if there are blanks. If I use a table it still pulls in blanks and ungroups my dates. I'm not sure if there is a workaround for that w/o updating the source data each time.