Table to json problem

Hi!

I have a large JSON file that I would like to split by company to own JSON sets, and create a nested json so that the company name and date is not repeated within the JSON. Is this possible to do and how? Tried json path, converting to XML but just cant figure out how :frowning:

“{

““Company name”” : “”! Company 1"”,

““Question”” : ““Revenue””,

““Answer”” : "“123"”,

““Year”” : ““2023-01-01"”

}”

“{

““Company name”” : “”! Company 1"”,

““Question”” : ““Personnel””,

““Answer”” : "“123"”,

““Year”” : ““2023-01-01"”

}”

“{

““Company name”” : “”! Company 2"”,

““Question”” : ““Revenue””,

““Answer”” : "“123"”,

““Year”” : ““2023-01-01"”

}”

“{

““Company name”” : “”! Company 2"”,

““Question”” : ““personnel””,

““Answer”” : "“123"”,

““Year”” : ““2023-01-01"”

}”

Thanks for the help, again! :slight_smile: