Challenge #151: Meta Parsing

[JoeS]

Perfect use case for the Crew Macro - Dynamic Formula.

A lot more efficient than other ways, especially if we were to be playing with more than 100 rows of data.

Also keeps the field order as well.

Take a look into the macro - it's modifying the XML, kudos to @AdamR  in creating this years back!

Spoiler

[KevinW]

Spoiler

[itestu]

Hello,

Here is my solution !

Spoiler

[danilang]

Nice challenge.  Tricky getting the output column order correct.

Spoiler

I went the transpose-join route as opposed to using an append fields/formula combo 

I got the column order correct by using the Data dictionary record ID as the key in the Cross tab.  These get sorted into the proper order then it's a dynamic rename

Dan

[PadmajaS]

Good one and my first one :)

[Number4]

Spoiler

[cgoodman3]

Too many tools compared to other solutions posted.

Spoiler

[cgoodman3]

Too many tools compared to other solutions posted.

Spoiler

[358802]

Spoiler

[AndrewSharot]

Boom!