Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI solved two ways. One that will only work if the incoming data doesn't change (i.e., no new countries or food items are added), and one that WILL work if incoming data changes.
Two ways - one absolutely avoid the obvious transpose -> crosstab solution and the second using the Crew macro to do this with no fuss.
Super helpful - and love that several people built this into a macro! My solution with my table:
Learned a tip....Always scroll down and check out all the options in the Crosstab as the Totals might be right there... Thank you for the challenge.