Challenge #25: Creating Merchant Combos

[Ziggy77]

Hi,

my solution is slightly different, and the outcome is differ a bit too from the posted solution. But the result meets the objective. Also, in the posted solution, there are [null] values in the Merchant1 column, which for me just seems "weird" (or illogical) that a "we want to know where else a customer went to, who went to [null] merchant at the first place...

In my logic, shouldn`t be [null] value in the Merchant1 column...

But correct me if I'm wrong... :)

[cgoodman3]

Spoiler

[Eleonora]

My solution

Spoiler

[RobertoEstrada]

In my case this is for me much simpler than posted solution and also I didn't understand why you have nulls as merchant 1; doesn't make sense to me. Hope you can clarify that point on further reviews.

[Verakso]

Here's my solution, slightly different, and then not really

Spoiler

Still Climbing
/Verakso

[RWvanLeeuwen]

The result may be slightly imperfect considering some NULL values, but it matches with the intended result.

Spoiler

[joemkcarr]

Used an iterative macro here to run through every permutation of vendors by User ID

[bdelarosa]

Did my best, seem I like to go the long way around to solving problems :)

[Hannah_Lissaman]

My solution :)