Can someone please help me out. I am trying to build a pivot table that will auto update and within the table do groupings by week. My source data headings are on Row 1 and data covers columns A-H. One of the sticking points I have is that their are some blanks in columns C,R,G,H. Can anyone tell me how to get this to work?