This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackThis 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.