It is certainly open to interpetation:

The '3 = Yes and show' option was all I was looking to do

ield_headers A number that specifies whether the row_fields and values have headers and whether field headers should be returned in the results. The possible values are:
Missing: Automatic (default)
0: No
1: Yes and don't show
2: No but generate
3: Yes and show
Note: Automatic assumes the data contains headers based on the values argument. If the 1st value is text and the 2nd value is a number, then the data is assumed to have headers. Fields headers are shown if there are multiple row or column group levels.


The 'row_fields' paramater passed to GROUPBY() should be [#all][#AAA]] so that the passed parameter does have headers so that a '3' will show them

I just made the assumption that Excel knew the table had headers so the row_fields parameter just needed the row field

But you have to read Microsoft's mind just right to figure it out, and I didn't