Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAbatch macro:
I can see how macros might be used for this challenge.
I did not need them. I found that simply using the "group by" function of many tools was enough.
Also, this challenge was poorly stated. There were a things that I had to figure out simply by looking at the data and at the desired solution. I liked that there existed multiple ways to accomplish the objective here.
In the end my solution was very simple. The join at the end is just for checking my answer.
I had to read through the comments and posted solution for this one, and agree with @RWvanLeeuwen that more details about the objective/nuances of the data would have been nice. I did it without a macro only because I like to visualize everything when I can.