Parse JSON column in table and output original columns with JSON data columns

[DougHawes]

I have a table with multiple columns that includes one column with JSON data. I would like my final output to include all the non-JSON columns along with the parsed columns from the JSON data.

Example Data:

User	Date	AuditData
Bob	1/1/2017	{ "Report": "Gross Sales", "IP": "111.111.111"}
Julie	1/2/2017	{ "Report": "COGS", "IP": "222.222.222"}
Elle	1/2/2017	{ "Report": "Gross Sales", "IP": "333.333.333"}

Desired Output:

User	Date	Report	IP
Bob	1/1/2017	Gross Sales	111.111.111
Julie	1/2/2017	COGS	222.222.222
Elle	1/2/2017	Gross Sales	333.333.333

[jdunkerley79 · Accepted solution]

Use a JSON Parse tool followed by a Cross Tab tool.

Note the JSON you provided lacked quotes round the key field. 

Quick sample attached

[DougHawes]

Thank you jdunkerley79, I tried the Cross Tab earlier, but did not have First Row checked.

[rrikkala]

Is there a way we can do this for multiple JSON type columns at once ?