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...

[apathetichell · Accepted solution]

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.

[hellyars]

@apathetichell   This works and you are correct, each aircraft has two lines associated with it.  That's easy to clean up.

Thanks!