Want to get involved? We're always looking for ideas and content for Weekly Challenges.
solved with Basic tools
Came up with my own solution using transpose, crosstab.
It is simpler but lacks the dynamic ability to add new keywords to the list, so if the list is 3 like the example this is an easier solution but isn't scalable