Parsing JSON Output to formated Excel Report

[Arundatla]

** Learning Altrexy ** We are using API to retrieve Data from some applications and the JSON out put is all in rows which we would like to format it appropriately as attached. Have tried using Transpose option and all but not giving appropriate results. Can some one suggest the right Options.

[martinson]

I hope you're having a great day. I have attached a solution to your problem. Using a Mulit-Row formula and recordID seemed to do the trick. Let me know if this helps.

Cheers,

George 

Bulien