Challenge #1: Join to Range

[ricki]

Spoiler

Have not used "Generate Rows" much, so was helpful reviewing the solution. - I took a slightly more manual approach.

 

[radu_gabriel]

My solution

[kglearner]

Spoiler

 

[AlexvanOs]

My solution

Spoiler

RegEx parse instead of text to columns because it allows me to select in one go. Then generate the 'missing' rows to be able to join. 

 

[richardatherton]

A solution to Challenge 1.

[PatForData]

Solution image

[KodyKlein]

Loved it! 

[johnyli168]

Solution attached.

Spoiler

[chuckleswk]

Finally getting around to the first challenges

Spoiler

[jonathanwillis]

Here's my solution