Split the Arrays inside a JSON object with as many rows as there are objects

{ "Region": "Asia Pacific", "Office": "Australia", "Location": [ { "name": "Brisbane", "Latitude": "-27.4690555", "Longitude": "153.0286812", "OfficeAddress": "Suite 4, L20 10 Eagle Street,Br...