Challenge #25: Creating Merchant Combos

[jevon]

Spoiler

[PeterGold]

Spoiler

Cartesian join (self-append) and lots of filters.

[pjdit]

My Solution

Spoiler

[JoBen]

Good stuff! This was challenging! Cheers!

[dharini]

My solution

[pasccout]

Here is my solution

[JoshuaGostick]

Added some formulas at the end so that the output would match the solution exactly.

[jssandom]

Maybe not the cleanest solution but got there in the end!

[yajing_wang]

this one is fun, so many way to solve it

Spoiler

Spoiler:

[jbranaum]

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!