Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIt turns out my hard path looks simpler than my easy path! I got the easy path on my own and needed to get some inspiration from the community for the hard path (thanks! @estherb47 @Joe_Mako) . Since I has not used the Arrange Tool before I gave it a shot. I will leave the Dynamic Replace for a later moment
Easy:
Hard:
Ok I admit I chose the easy path. I didn't need to use the 'Company Names' table but I knew it was part of the more challenging solution of "not using: join, crosstab, transpose, multi-field formula or multi-row formula." but I couldn't see how to do that approach until I saw the solution. I wasn't familiar with one of the tools used (although I understood the concept) and really admired the solution. I wish I'd found this tool sooner as I know it would have saved me time in doing some comparing data.