Challenge #338: Let's Summarize!

[ThandoCalana]

Potential solution

[phottovy]

Another one bites the dust!

Spoiler

[Stacies]

Solved!

[Will_Condon]

Prepping for Core Cert.  Selection matches, a few are not in the same order as solution output within Average Rating.

Spoiler

 

[AYX106087]

I'll take a look at the answer as I feel I came up with an hectic answer but hey at least it works (kinda)

[julian-harrison]

Here is my solution.

[jwbtx20]

I'm going for Core certification and haven't quite learned RegEx yet. My formulas to standardize the dates are a little clunky with some conversion errors in the middle of everything, but I was able to get a valid year (between 1947 and 2021) for all original rows of data :)  

Spoiler

[BS_THE_ANALYST]

If I summarize my feelings about this one: can't figure out order for concatenation to match answers 🥱😂

Spoiler

Time Taken: 12:43

 

[michaeljohnson]

here

[AndyJay]

My solution