Challenge #410: Optimizing Winter Sports Inventory

[MMC15]

Spoiler

[Zhengyi]

Nice practice.

[Manav_Sehra]

My solution is attached. 

Spoiler

 

[PhilipMannering]

Solution attached.

Spoiler

[Lucy_Hickman]

Spoiler

I noticed that all the data was in the correct order, but will many null values. I transposed the data into one column, removed all the null values. then used the sample tool to reorganize the data. 

[emmaob98]

Spoiler

[james_western_HUN]

First challenge I've tried.

Spoiler

I tried to stumble through a multirow formula before peeking solution. the Mod 5, Concat, and transpose was very elegant.

[gerda]

Spoiler

Here's the solution.

[Carolyn]

A little ugly but I got there!

Spoiler

 

[Ray_Pospisil]

Alteryx, pandas, pyspark and SQL solutions