Forum Discussion
Solved
Pivot table issue
Apologies- this may be the wrong forum for this type of question but I'm tearing my hair out. The problem - I have a flat excel workbook that has within it data similar to the structure below: ...
philbloggs
Detlef_Lewin is rereferring to using Power Query to Unpivot the data first, this then converts your multiple columns into a 2 columns as per the attached file. This is then ideal for Pivot Table use.
Click inside your data and turn it into a Table (using Ctrl T) then go to Data - From Table/Range (or it may say from Sheet depending on your version of Excel)That opens Power Query
Then Right CLick the first column and choose Unpivot Other then click Close and Load To... drop down and choose Data Model connection only
Your data is already in a crosstabular structure. You have to unpivot first before you can do the pivot table.
Thanks for getting back to me so quickly.
The raw data isn’t in a pivot chart- it’s a the output from a MS forms questionnaire as an excel spreadsheet.
Phil
The raw data isn’t in a pivot chart- it’s a the output from a MS forms questionnaire as an excel spreadsheet.
Phil
- It is still a crosstabular structure.