Want to get involved? We're always looking for ideas and content for Weekly Challenges.
My solution attached; thanks!
Yes, I can overcomplicate a ham sandwich. Got there, but with all the condiments.
A different approach.
Tried to do a macro and couldn't quite get it to work right, went with tiling and formulas instead.
Here's my solution.
Edit: And yes, having looked at others I'm kicking myself for not doing the selection with a single formula tool - doh!
Looking at other solutions, I guess I could do without a transpose.