Here is my working solution. My feeling is that I use too many steps (multiple transpose and crosstab series) but don't see the simplification just yet. Will get there with more experience.
Pleased with the results (and the course! well done by the authors!)
Cheers, Mark