How to copy data from pivot with saving of groups and structure

[Ekmelnikov]

I often have to copy data from pivot tables in order to make sales reports later.

In the pivot table, my data is structured according to the following hierarchy:

Brand name-season-category

How can I copy the data from the pivot table so that the data is like in a regular table, but the grouping is preserved

 

[Deek6t8]

you can set the design of the pivot to tabular and repeat item labels before you copy the data that will preserve your groupings etc.