Format JSON Output

[tf05]

I have the attached output from a JSON Parse but stuggling to get into in the correct format using crosstab etc.

JSON Name = Column

JSON_ValueString = Values

Any guidance will be much appreciated.

[Luke_C · Accepted solution]

Hi @tf05 

You could use a multi-row formula tool to assign an ID before crosstabbing. In this case the assumption is the triggerDateTime is the first field for each set of values: