Forum Discussion

Brass Contributor

Jun 11, 2022

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 ...

12June_Pivot outreach SOC treatment_blinded.xlsx12 KB

excel

Riny_van_Eekelen
Jun 11, 2022
AmyYang Perhaps the attached PowerQuery solution works for you.

12June_Pivot outreach SOC treatment_blinded.xlsx21 KB

Riny_van_Eekelen

Platinum Contributor

Jun 11, 2022

AmyYang Perhaps the attached PowerQuery solution works for you.

12June_Pivot outreach SOC treatment_blinded.xlsx21 KB

hnawaz412

Copper Contributor

Dec 11, 2022

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.