Creating Pivot on Database Split on 7 Sheets

Hi guys,

Nice to meet you, I'm Marco and I'm Italian

I'm here as I need help in order to build a pivot table that is driving me crazy :\ The matter is that I have a database that is so huge that it is split into two sheets (each sheets has the same headers) and, starting from it, I need to create a pivot...

I created a simple version of the file I'm working on that I'm attaching to the post, just for your understanding.
The problem is that, as you will see, in the pivot I cannot use "Country" as a label, as Excel includes it in the label "Columns"... Is there a solution for this? In the original file I have kinda 10 columns more in the database that I cannot use as labels.

Many thanks in advance!!!


Marco