Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Cartesian join (self-append) and lots of filters.
Good stuff! This was challenging! Cheers!
Here is my solution
Added some formulas at the end so that the output would match the solution exactly.
Maybe not the cleanest solution but got there in the end!
this one is fun, so many way to solve it
Here is my solution.
Was making some headway and got stuck with how to remove duplicate occurrences where the merchant names were just swapped.
Partnered with @Justin_0 and he gave me a great idea that i was able to accomplish using a multi-row. Quite clever sir. Well done!