Your hunch is correct, the column labels field has to have valid column names for pivot to work. A potential future enhancement for the macro is to provide a column prefix or column rename ability; in the meanwhile creating an intermediate CTE to rename field values is a good workaround.
1 Like