We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
This one comes up relatively frequently and is a really nice example in Alteryx of how easy it is to pivot your data.
I made a macro out of my solution for challenge #59 and was able to use that macro here.
I concatenated all the purchases into a single cell per row.
The macro counts how many time each letter appears in the concatenated value and generates a code based on the counts of each letter
I used the summarize tool to count how many unique anagram codes appear.