Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi,
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... :)
The result may be slightly imperfect considering some NULL values, but it matches with the intended result.