Hello,

I have the following pivot table :

Continent     Country      Sales
__________________________
Europe        France        100
                 Spain          200
                 Italy            300
Asia           Japan          100
                China           200

I understand that "Europe" and "Asia" do not get repeated on lines 2,3
and 5 because they act as a kind of "header" for the countries.

But the purpose of my table is to do an extraction, that will be later
used for data manipulation. Therefore I need all lines to have all
elements, something like :

Europe        France        100
Europe        Spain          200
Europe        Italy            300
Asia           Japan          100
Asia          China           200

Is there a parameter in Pivot tables that will let me do this ?
Thanks
Antoine