Transpose Fields and Values

hellyars

I have a json input from a web scrape.  I need to transpose the data into a traditional table format.  The Field Names are in JSON_NAME. The Values are in JSON_ValueString.  Records (rows) start with each reference to "Aircraft".  

From this...

 

To this...

transpose_inputFromJSON.yxzp

apathetichell

This would fit your description - but it seems like every two row may relate to one aircraft. You'd need to modify if if that's the case.

2021-03-01.png

transpose_inputFromJSON.yxmd