Poblem transposing data

[acemccloud]

HI 

I am having a problem transposing data which I converted from a JSON file; attached for the reference. I want to move all the JSON_Name to column headers and associated values to rows underneath it. I tried using crosstab but the problem I am facing is that it offers me option to concatenate or take the first row only OR I am doing something wrong. Can someone please help? 

Thanks,

ace 

[cmcclellan]

Crosstab is definitely what you need (attached), but it doesn't look like it got all the fields. 

Just use it like this:

[j_acon · Accepted solution]

Hi,

Like what cmcellan said, CrossTab is the way to go. I just added an extra step, give the records an ID to make things easier. I have attached the workflow too, written in 2018.1.4

[acemccloud]

Thanks j_acon. Its working. Thanks for your help. :) 

[acemccloud]

Thanks :)