Merge Multiple JSON files containing the same 2 objects

[angrycip]

Hello, I have multiple JSON files uploading to a Sharepoint Folder. These files all contain the same 2 objects with sub-objects.

So far I managed to:

- list all the JSON files in that specific folder

- Combine files using the Content Column (i masked the names of the gateway but can consider a_gateway and b_gateway)

This results into having 2 rows per JSON file that show the object. It's a repeat object. My goal is to combine all the elements in the name column into just 2 rows that have all the data merged. 

Each of these 2 objects contain 3 columns with the same name that contain Lists of records.

[Syndicate_Admin]

please provide a couple of sample files and indicate the expected result.