After JSON Parse, I get the attached data. The data of the JSON_Name field is a combination of data and string. I want to parse it, separate the number and string, and then convert strings to column headers.
The attached file includes the source data sheet (the data need to work on) and the target sheet (to explain the target view I want to get).
