Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Indent mode on the style tab:
Hello Jonathan
I appreciate your help to provide very close help.
You saved my day *****
Thanks