Transform Data from PivotTable into normal Table

Hi everyone,

As shown below with to images: I have a PivotTable were use the results from a survey and want to match count of the different answers with the country of the respondents. If I do it manually, the easiest way to get a nice chart, was to copy-paste the pivottable into a new sheet as "values", so I could then manually transform the data into a new table and create different charts with it. But since there is quite a lot of data, I was wondering if there is any automate or is way to do this? (before I start work out some kind of a code in R :D)

I am also interested in different apporaches.

First image: PivotTable, Second Image: How I want to data to look like.

Thanks a lot for any help
Cheers,
Tim

My PivotTableHow I want to data