you have to sort out the Data range in Step 2Ken, The "blank" column definitely proves that Excel is looking at a blank row or column in the source data.

The blank column in the pivot table is just a symptom of the problem so deleting it won't change anything. You have to modify the data range that Excel is looking at in Step 2 of the wizard. To do this (exact wording depends on your version of Excel):

The data range in the box needs to be adjusted. If you look at the broken lines moving around the block of data, you will see that they are enclosing a blank row or column somewhere. That's what's causing the Group function to fail because there's no date there.

So you need to go ahead and correct the data range so that the broken lines surround data and not blanks. Then Finish - right click for menu again -Refresh Data.

Having said all this, sometimes Group still doesn't work even after you have corrected the data range! In that case, you will just have to delete the pivot table and start all over again. But at least when you get to Step 2 you will make now sure that you select the data range correctly. David