0
1
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
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