Pivot table headers

[Anonymous]

Hello All

I have one pivot table as below

Group  Item#  ItemName  Q1     Q2    Q3    Q4

Soda   S1      Coke          10      20    30     40

           S2      Pepsi         11      22    33     44

Chips   C1     Chips A      21     22     23     24

           C2     Chips B      31     32     33     34

Dairy   D1      Milk          111    121   131   141

           D2     Yougurt    221    222   223   224

Now I want above table as below

(Group on top not as column)

    Item #  ItemName   Q1    Q2    Q3     Q4

Soda

      S1     Coke           10     20    30      40

      S2    Pepsi           11     22    33       44

Chips

      C1   Chips A         21     22    23       24

      C2   Chips B         31     32    33       34

and so on

I appreciate everybody's help

Thanks

[JonnyPoole]

Indent mode on the style tab:

[Anonymous]

Hello Jonathan

I appreciate your help to provide very close help.

You saved my day *****

Thanks