Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIt was a challenge to figure out how to flip that table.
A well placed identifier did the trick for me.
Solved.
I kept coming up with a different total. Took me a while to figure it out. I realized the Own Pairing names didn't always match the Pairing names. For example, Amber vs Amber Ale , Cherry vs Cherry Jolly Rancher. I cleaned up the names, went together smoothly.
You won't want to copy my workflow, because I used WAY TOO MANY tools to get there, but I got there.
I have never heard of some of these pop-tart flavors...but I want to try them! Chocolate Chip Cookie Dough? Yes, please! Watermelon Jolly Rancer? Also, yes please!
Fun!!
I found this solution's output data has duplicate row. Just notification.
Learned from solution.