While I solved the problem with more tools than some, I needed some extra tools because instead of a join I used find replace. Nesting logic in a multi-row formula could remove another tool, but once you're there and getting good results I opted for maintainability. Kudos to all.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
to my youTube channel.