Excel Pivot table format

I have the following in a excel pivot table

            Summer15 Fall15 Winter16 Spring16 Summer16 Fall16 Winter17  Sum
 a   pro1    0        0                  0        0       0        0     0
 a   pro1                        1                                       1
 b   pro2     0                                                          0
 b   pro2              1                                                  1
 b   pro2                                 2                               2
 b   pro2                        3                         3        6     12
 b   pro2                                          4                      4

where pro is a Row, seson in column and value is a value

I would like to get the following format instead:

            Summer15 Fall15 Winter16 Spring16 Summer16 Fall16 Winter17  Sum
 a   pro1    0        0         1        0        0       0        0     1
 b   pro2    0        1         3        2        4       3        6     19

flightless13wings

Posted 2016-08-31T20:20:34.883

Reputation: 7

Do you only have the "Pro" field under the "Row labels" section? Looks like you might have both the "Pro" field as well as the value field under Row labels. – mtone – 2016-08-31T20:36:02.453

I have other variables in the row labels, but I double checked to see that value was not under row labels. – flightless13wings – 2016-08-31T20:39:24.050

check your data source, if you don't have several versions of proX (with one or more trailing space). You can select in the pivot table the different pros and press F2 to make a quick check. – visu-l – 2016-09-02T06:52:09.457

Excel Pivot table format

Answers