Challenge #102: Tabulating Flu Data

[markcollin]

My solution below! Thanks for a lovely challenge!

[Mattpannuzzo]

My solution :)

I might attempt the week by week comparisons later.

Spoiler

[mascarenhas_lucas]

Spoiler

[daniel_ferreira]

Follow my solution attached...

[StevenBetts]

Didn't have too many problems with though, although I feel like there might be a way with fewer steps - will read through everyone else's solutions :)

[SeanAdams]

Very similar solution to others.

[ivoller]

Relatively straightforward. Looking through the solutions afterwards I discovered there are better (more creative) ways!

[Wouter]

My solution:

Spoiler

[mickael_gest]

My solution :)

Spoiler

[mceleavey]

Nice and simple, but a little bit of trickery around the column names if you use crosstab. Beware!

Spoiler

I first filtered out the nulls and used "Dynamic Rename" to take the column name from the first row of data. I then replaced the non-alpha-numeric characters and replaced them with letter combinations. I then cross-tabbed the data with the appropriate grouping and used the dynamic rename tool to reverse the previous character replacement.
Simple.