Hello!
I am trying to create a summary report for my data as my pivot tables are becoming too huge.
My source data looks something like this (in a separate sheet about 450 rows):
And I would like my summary table to look like this:
At the moment i have a pivot table for each study which just shows a count for each column- the team i send the report to are ok with it but its just becoming so huge and i cannot fit a single study on a slide.
Ideally i would like a status per study for each person? I thought i could perhaps use the pivot of the source ? that might make things more simple, but if im honest i have no idea how to do it and have watched so many youtube videos that are not quite right.
any ideas on how to do this?
Very grateful for your support!
Thanks!
C
I am trying to create a summary report for my data as my pivot tables are becoming too huge.
My source data looks something like this (in a separate sheet about 450 rows):
Name | Study | requested | assessed | approved |
joe blogs | study 1 | 01-Jan-20 | 02-Jan-20 | 03-Jan-20 |
joanne smith | study 1 | 01-Feb-20 | 02-Feb-20 | |
joe blogs | study 2 | 01-Jan-20 | 02-Jan-20 | |
joanne smith | study 2 | 01-Jan-20 | ||
joe blogs | study 3 | 01-Jan-20 | ||
joanne smith | study 3 | 01-Jan-20 | 02-Jan-20 | 03-Jan-20 |
And I would like my summary table to look like this:
Name | study 1 | study 2 | study 3 |
joe blogs | approved | assessed | requested |
joanne smith | assessed | requested | approved |
At the moment i have a pivot table for each study which just shows a count for each column- the team i send the report to are ok with it but its just becoming so huge and i cannot fit a single study on a slide.
Ideally i would like a status per study for each person? I thought i could perhaps use the pivot of the source ? that might make things more simple, but if im honest i have no idea how to do it and have watched so many youtube videos that are not quite right.
any ideas on how to do this?
Very grateful for your support!
Thanks!
C