I have recovered database information that I am trying to reconnstruct, the data was given in JSON format like this:
Mostly, I need the X and Y data to plot the points, but the other attributes are important as well. Looking for ideas for getting excel to format the data similar to the attached image
"layerServerGens":[{"id":0,"serverGen":234091}],"transportType":"esriTransportTypeUrl","responseType":"esriDataChangesResponseTypeEdits","edits":[{"id":0,"features":{"adds":[],"updates":[],"deletes":[{"geometry":{"x":434757.92663790932,"y":2329162.1516300468},"attributes":{"FID":781,"GlobalID_3":"7786EC58-1FDD-448A-9F11-22A52D67FC70","Long":null,"Lat":null,"OWNER":null,"INSTALLATI":null,"COMMENTS":null,"HEIGHT":null,"MATERIAL":null,"STYLE":null,"GLOBALID":null,"NAME":null,"BUILD":null,"STATUS":null,"GlobalID_2":null,"CreationDa":null,"Creator":null,"EditDate":null,"Editor":null,"layer":null,"path":null,"CreationDate":1664812533657,"Creator_1":"admin.wideband","EditDate_1":1664812533657,"Editor_1":"admin.wideband","NODE":null}},{"geometry":{"x":1059115.5835527368,"y":2865797.5113765462},"attributes":{"FID":782,"GlobalID_3":"F83F39EF-F428-4A3A-B494-4FBB9EA5B542","Long":null,"Lat":null,"OWNER":"AMERICAN TOWER","INSTALLATI":null,"COMMENTS":null,"HEIGHT":null,"MATERIAL":null,"STYLE":null,"GLOBALID":null,"NAME":"TOWER-AT","BUILD":null,"STATUS":null,"GlobalID_2":null,"CreationDa":null,"Creator":null,"EditDate":null,"Editor":null,"layer":null,"path":null,"CreationDate":1677264270803,"Creator_1":"rsigns.wideband","EditDate_1":1677264316967,"Editor_1":"rsigns.wideband","NODE":null}}
, ...... format repeats and "geometry" represents the begining of each new dataset and continues on for a long time ....Mostly, I need the X and Y data to plot the points, but the other attributes are important as well. Looking for ideas for getting excel to format the data similar to the attached image