Challenge #22: Identify Values to Aggregate

[ed_hayter]

Spoiler

[The_Rad_Valentina]

Nice and easy one. 

[bo_peng2022]

My solution

[ntakeda]

My solution,

Spoiler

[mithily]

Spoiler

used text to columns and regex to solve

[SamBreen]

Spoiler

Spolier

 

[Computernerd]

I guess I cheated on this one as I didn't use RegEx.  After seeing the solution, I did learn a new technique.

[rachel_lynch]

Spoiler

 

[Towers]

fun one! Love regex

Spoiler

 

[olga_strubbe]

Thank you, @GeneR!  This was a neat challenge - gave me an opportunity to practice RegEx.