Forum Discussion
How to use a PivotTable with unique columns?
Since your data on Responses Tab was already in pivoted form, I used Power Query to transform and UnPivot the data on Responses Tab to create a Pivot Table on a New Sheet (Green Tab).
To do that, I converted the data on Responses Tab into an Excel Table and named it "Responses", loaded the data into the Power Query, removed the TimeStamp column as it was not required in the Pivot Table to be created, UnPivoted all the columns, renamed the columns and loaded as a Pivot Table Report on a New Sheet.
See if this is what you were trying to achieve.
I'll try to upload it when I'm home, but I feel like I'm just missing something basic here or misusing the Table that someone should be able to point out.
Okay. Am including a quick-and-dirty example that achieves what I believe you are trying to do. If not, try uploading a sample of your data at your earliest convenience.
Thanks for making that! I appreciate it, but it's not quite what I'm looking for.
Here's an example of what I'm dealing with, in the PivotTable sheet you can see the exact table I'm trying to work with. I'm not sure what to put in the Columns section if it can only handle one column at a time from my Responses sheet.
Since your data on Responses Tab was already in pivoted form, I used Power Query to transform and UnPivot the data on Responses Tab to create a Pivot Table on a New Sheet (Green Tab).
To do that, I converted the data on Responses Tab into an Excel Table and named it "Responses", loaded the data into the Power Query, removed the TimeStamp column as it was not required in the Pivot Table to be created, UnPivoted all the columns, renamed the columns and loaded as a Pivot Table Report on a New Sheet.
See if this is what you were trying to achieve.