API result combines multiple "Things" in one "Thing" - want to split it up


not sure if that is an API question or maybe a database workflow. I am now calling an API - this works now and i get a reply fro the API. The API reply should be a list of items - of course i want each item in a single and new “Thing” to show it propperly in a RG…

You can see the XLS that should be created using a RG and the current DB format i got…
Many THX for your hepl!!! Love this forum :heart_eyes:

  1. How can i split up L1,L2,L2 in single line items…?
  2. How can i merge L1,L2,L3 into a master List for the RG…?