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.
