Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution
I loved seeing everyone's approach to solving this problem, and also kick myself for not thinking of using the generate rows tool! Even when submitting the challenge, I learn something new. 🤓
The solution provided was one of two different ways we had originally come up with building the workflow. Below is the second approach which utilizes an Advanced Join macro that is available on the gallery.
Cheers!
Phil
I love the chance to use a join as a filter...
I like Cross Tab and Transpose.
Good practice with generate rows