how to transpose/pivot repeating rows into columns

[1737280]

I'm working on a workflow that reads JSON data and processes the relevant datapoints into tabular data.  I got to the following format after a series of Select, Filter, and Formulas once reading from the Json Parser:

JSON_Name	JSON_ValueString
id	123
firstName	John
Office	New York
Revenue	150,000
id	135
firstName	Mary
Office	Chicago
Revenue	230000
id	179
firstName	Joe
Office	Miami
Revenue	175000

You can see it's 4 rows repeating with different values.  How can I transform into the following structure?

id	firstName	Office	Revenue
123	John	New York	150000
135	Mary	Chicago	230000
179	Joe	Miami	175000

Thanks for any suggestions in advance.

[fmvizcaino · Accepted solution]

Hi @1737280 ,

Attached is an example showing how to do it. 

Let me know if this works for you.

Best,

Fernando Vizcaino

[1737280]

Thank you @fmvizcaino.  Adding the dummy field as the key wasn't what I thought of. ; ) 🙂  It works perfectly!