Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALike others, my instinct was to go with a batch macro, so I may have had a quick peak at @Aaron_Harter's solution. Much simpler approach:
Going for the record number of multi-row formula tools in the solution 🙂
Nice one! @RaviP Not the most intuitive but very simple.
Nice quick challenge for this week, great use case for the First and Last functions of the Summarize tool.
Solution attached