The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.
I absolutely had to look at the solution to understand how and why to transpose and then cross tab, as well as figuring out why my if/then statement wouldn't recognize the individual words in the column. Turns out that contains needed to be used as it's own function instead of IF a Target equals something.