Forum Discussion
How to use a PivotTable with unique columns?
Hey, I'm trying to separate three columns of data by 9 different possible rankings in a PivotTable. Right now the columns are being combined together into the first one, leading to them all having the same values as the first column. It looks like this:
I've tried lots of different things with the table and this is the closest I've gotten to get unique values. As you can see, the 2nd and 3rd rows are copying the 1st row's data. They should be unique to their own respective column's data, but I'm unsure of how to do that (or if it's even possible with this setup?).
Thanks if you can help with this,
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.
- Please upload a sample of your data.
- Away from home right now, but basically it's a Google Form response sheet where each column = 1 response. Each response can select one of the ranks (Unkranked, Bronze, etc.) for each of the three roles (Tank, Damage, Support) - each being a separate column. This PivotTable is only using the Tank's response column as it's the first one, I'm trying to make it use all 3 roles' so that in that picture not all the numbers are the same for each Role.
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.
