Cloud Quest #10: Reformatting Data

[bradshaw]

Nice one.

Spoiler

[geoff_zath]

Spoiler

 

[RWvanLeeuwen]

Thanks @AkimasaKajitani: this helps.

Of note: the formula should be used as REGEX_Match(String, pattern, icase) and does not allow reversal of String and pattern arguments it seems.

[Ladarthure]

Nice one, did not went for transpose then crosstab way though or did I?

I've done a first method which works well but is unable to identify if there are new headers appearing and a second one which is more dynamic

[mshishido]

Nice one

[ggruccio]

I sometimes over-think them!!!

Spoiler

[TonyaS]

Spoiler

Well, in attempting to create an app in App  Builder for extra credit, this helped me uncover a potential defect in App Builder. Win Win! 

[logdog0411]

Spoiler

 

[phottovy]

This one took me a minute to get started but once I got started, I was able to find a fairly simple solution:

Spoiler

[patrick_digan]

Spoiler