Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
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