How to parse and align the json data

[AKPWZ]

How can I align the given data in a specific row and column, can someone please help me. Thank you

Input Data:

Output Date:

Sample file attached: -

[Luke_C · Accepted solution]

Hi @AKPWZ 

Here's one way. Separate the headers from the rows and join the two datasets together. Then you just have to cross tab. 

[AKPWZ]

@Luke_C  thank you so much! It's working for me. :)

[Luke_C]

@AKPWZ Happy to help! Be sure to mark the solution so others can find it easily in the future.