How to use Cross Tab?

[Joker_Hazard]

Hello guys.

I am trying to use Cross Tab tool but no success.

I have this data:

and I would like it to be like this:

Any ideas? 

Tks

[AngelosPachis · Accepted solution]

Hey @Joker_Hazard ,

Use a transpose tool and select [CNPJ_FUNDO] to be a key column and the other two to be Data columns. In the output of the transpose tool, you should have 3 columns in total named [CNPJ_FUNDO] , [Name] and [Value] , where [Name] would either be "Variance_Rentabilidade" and "StdDev_Rentabilidade".

Then use a cross tab tool, group by the column [Name], select your headers to be [CNPJ_FUNDO] and values to be taken by the [Value] field. Select a method to aggregate the values (a sum should be fine) and run the workflow.

That's it, that should do it.