Challenge #25: Creating Merchant Combos

[Spurs]

Spoiler

[BS_THE_ANALYST]

Fun stuff! Love a self-join + filter logic for permutations

Spoiler

[Hammad_Rashid]

[Amilley]

**Spoiler**

Transformation is always a fun exercise!

[dougbaron]

Spoiler

[Raj]

Sol

[HardikJani]

Thank you for another interesting challenge. I used the arrange tool to get the data in required format for two different cases i.e count=5 and less than 5. And then filtered out the null values from merchant 2 column. Looking forward to learning from better solutions.

[Longa]

My solutions.

[ed_hayter]

Spoiler

Probably should have been a macro

[olga_strubbe]

Spoiler

I followed a similar approach to the solution provided, was a bit confused, I admit, as to why not all combinations of merchants for a user have been counted.