Challenge #7: Download Data and Parse JSON

[bmarx112]

Spoiler

[Illya]

My solution

[Nicholas_Bignell]

Another recording to show the unnecessarily long way to do this...

[AlexSimpson]

Enjoyable Challenge!

Solution attached

[Kong]

Keep going challenges!  Challenge #7 completed.

[SamGon]

Solution:

Spoiler

Once the data is downloaded and parsed, I split it to identify the column headers and the underlying data. The column split is used to identify the unique data record ID and the column heading ID. The column headers are joined to the data by using Find/Replace and the column ID. The data is reformatted using Crosstab and Dynamic Rename to correct the column headings since the crosstab added underscores.

[tdonohue001]

I had to add a sort at the end (compared to the provided solution) to get it to match. But got there in the end! 

Cool seeing how to connect to the internet....possibilities are endless! 

[JamesCameron]

My effort.

Spoiler