Challenge #25: Creating Merchant Combos

[Waynemk]

I think mine is a novel approach. 

Spoiler

can you tell i love the multi-row formula tool?

[ggruccio]

Took several steps to get there....

[dsmdavid]

Learning my way around macros, so trying to use them all the time - I also thought it more logical to have the nulls/empty in the second column...

[PhilipMannering]

Solution attached.

Spoiler

[LandonG]

Solution attached.

[jasperlch]

Solution attached.

[msicak]

I had to cheat and look into alex's solution for a bit of inspiration (namely, the multi-row, I knew I could use it to solve this). Thanks, and attached my solution - non-scalable and (somewhat) scalable, even if not fully flexible.

Spoiler

[jamielaird]

Solved with a cartesian join and a bit of filtering:

Spoiler

[MaxGiegerich]

I used a filter expression to most of the heavy lifting here. Took a bit of fiddling but reduced the number of tasks required significantly. 

[JosephSerpis]

Challenge Completed