How to get a desired output from a JSON indexing data ?

[AKPWZ]

In my limited knowledge I tried few things, like I used "Regex tool", "Multi-row tool", "Cross Tab" etc but nothing is working for me. 
Can someone please help how I can learn and get the desired output?
Here is the input data screenshot: - 

Desired Output: - 

And this is what I was trying to do:

Please find the excel file (Input data and desired output) as attached :-

[FilipR]

Grouping by ID in the Cross Tab tools and replacing Append Fields with Join will fix the issue.

Please see attached.