Challenge #189: Billboard Top 100

[pburke]

Definitely used more tools than needed

[uk_msmt]

Solution attached. 

Spoiler

[CRM66]

A fun one.

[apathetichell]

I learned decades based upon what I have just found out is the Farmer's Almanac definition of decades - and under that definition the results are a bit different from those provided... More background to this methodology:

https://www.npr.org/2019/12/27/791546842/people-cant-even-agree-on-when-the-decade-ends

One other quick note - I believe the correct output as provided does not remove "the" from band names so that both "Beatles" and "The Beatles" are different band names.  While Discogs lists six bands whose names include "The Beatles" (including Ringo Starr and friends), there is apparently no band who decided to adopt "Beatles" as a name and attempt to launch a career.

I standardized band names...

[Toons]

My solution (with a macro !) :

Spoiler

Workflow :                                                                                                         Macro :

[BeginnerMindset]

Spoiler

[Airedelapaz]

Solution. However,  I lost the space between artist names when I used the concatenate. 😑 What did I do wrong?

Spoiler

[binuacs]

Spoiler

[rkraan14]

[scchahar]

Solution using sample tool