Pivot Table help

[Pryach]

I have data that looks like this:

Please Login or Register  to view this content.

I want to make a pivot table where the end result is this:

Please Login or Register  to view this content.

However I am having trouble figuring out how to do this. About the only thing I know for sure is I want to have the Month column as my Column Label, but I can't figure out how to put the Routine Count and STAT Count, as well as create the "Total Studies" row and the "Percentage STAT" row.

Thanks for any help.

[oeldere]

With the macro below and after that a pivot table.

See the attached file.

Please Login or Register  to view this content.