I am trying to organize a dataset regarding trade. I have the following columns: ReporterName, TradeFlowCode, Year, Category, PartnerName, TradeValue. I would like to reorganize this data so I can get something that resembles the following pivot table:
I know how to group and summarise the data by a single value - country or category. So I can get the information regardin the summarized value of trade with a given region/country or a category. However, I have no idea, how to first group by PartnerName(country or region) and then to have a category breakdown of different commodities traded with that Country or Region (as shown above in the Excel pivot table).
Thanks in advance for any ideas!