How to create a pivot table in this case?

[msexcel]

Hey,

How to explore the spending amount by creating a pivot table for the categorical variables and computing the average of spending in each category?

Thanks,

 

[bobhc]

How to explore the spending amount by creating a pivot about an upload