Cross Tab Query

[hii_amit]

Hi,

I have below data

Desired Output required as below

[philipmannering]

Hi @hii_amit ,

The difficulty with getting this exactly the same is that Alteryx doesn't allow for nested headers, and field names must be unique.

See if the attached gets you most of what you need!

[hii_amit]

Thanks Philip