How do I get the row field headings to repeat in a pivot table?
The row headings show once in a PivotTable, and there’s no setting you can change, to force them to repeat. To create a table with a heading on each row, you could copy the pivot table, paste it as values in another location, and fill in the blanks. In the beta version of Excel 2010, this feature is finally available. I am trying to group dates by month and I get an error that says ‘Cannot Group that selection’. If the field contains blank cells, or contains cells with text, you’ll get that error. To resolve this, here are some suggestions for fixing the PivotTable grouping problems.
