Multi-Dimensional Json file to Table

Hi

Can anyone help me with this json file scenario?

I have a folder with multiple json files having the same structure. Each json file has some columns having single value whereas some other columns have list values(list- value) pair. Want to generate a report that has data from all the files in this folder. 

I started by taking a single JSON file, transformed the list columns of it into separate tables....making each of it as a separate query( I added an index column).  So for a single json file, apart from the source I have multiple queries corresponding to tables. Relationships are also set between all of these queries.

How do I  generate a tabular report with source columns and also include the list column names in it,.... corresponding to a master record, there are multiple list values. I am not able to get the values of the list in the report.

Can anyone suggest me how to proceed?

Also I plan to append the queries of the rest of the json files to these, is that the right approach?

Thanks