Challenge #468: Many-to-Many Like it Hot – Part 1

[RolandSchubert]

Spoiler

[BransonJamesFarley]

Spoiler

 

[lwolfie]

Nice Monday Morning brain warm up.

[JBevan89]

my solution attached

[olga_strubbe]

Thank you, James!  This was a lot of fun.

Spoiler

[Kenda]

Spoiler

[tkemp]

This works, but I don't like the mechanism for getting 1x . . ., 2x . . . in the group by. 

Is there a way to configure Concatenate in a Summarize to do it this way instead of providing the list? 

[braveraj]

Spoiler

[jfissel]

Spoiler

[TurboToad]

Spicy!🌶

Spoiler