Cross Tab Issue

[diegeid]

Hi,

I have a table with the following table:

I want to have a new table with the values for each category and region in 1 column like this:

i have tried using the cross tab tool without succes

thanks

Diego

[apathetichell · Accepted solution]

you should be using transpose - with category as a key column. you then create your combo field name as [Category]+" " +[Name]

[binuacs · Accepted solution]

@diegeid