Forum Discussion
Solved
Pivot table question
Hi,
Could someone show me how to make a pivot table using the attached example table?
I would like to summarizes the count of each drug from Column B to F). And then also list the manually entered additional drug text from Column G?
For example, Country A would show 1 pembrolizumab, 9 platinum-based chemotherapy, 5 EGFR inhibitor, and 1 other drug which is EGFR inhibitors osimertinib and Afatinib.
Thank you,
Amy
Jihad Al-Jarady This is an old post and I don't know what more I can add then what is shown in the file I attached earlier. The query is merely extracting the individual drugs from the "Other" column so that it can be pivoted with the drugs that are in their own column.
Anything particular that isn't clear?
- Pivot table file size isssue 88Mb not loading and taking more then an hour to open. anything wrong with pivot table or any suggestions as having a really bad time.
- Dear Riny, apologies I did not get notification that you had replied.
I downloaded your attached excel however unable to see the PowerQuery solution.
I'm wondering if you don't mind, could you re-share your solution?
Thanks very much,
AmyAmyYang But it's in the file. On the Data ribbon, press Queries and Connections.
