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

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 :-

Syllabus.xlsx

Developer

Developer Tools

Regex

Output

Custom Tools

Dynamic Processing

Expression

Accepted answers

All comments

Qiu

@AKPWZ
We can split the data stream to a Common and Specific part, then some processing as below.
Please note this kind processing is not so dynamic 😂

0710-AKPWZ.yxmd

AKPWZ

@Qiu thank you so much!
So there is no way to make it or process it dynamically?

AKPWZ

Hi @FilipR will you be able to help me on this? Thank you!

FilipR

@AKPWZ please see the attached. 😀

Cross Tab JSON.yxmd

AKPWZ

Hi @FilipR thank you so much for your response, its working the way I was expecting. But it's not working if we have more and different number of ID's (the first column). Could you please help me out to learn that dynamic process. Thanks!

FilipR

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

Please see attached.

Cross Tab JSON.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703