Suppose I have the following values

A B C

a x 1

a y 12

. . .

. . .

b x 4

b x 5

. . .

. . .

c y 4

. . .

I am doing a pivot table by keeping A & B in column values and summing C in data. I want to get all B values for A column. for eg.

in this case we won't get y for b and x for c.

I know we can put B column in row to get all B values in PT. But if we have an one more variable in row we will have a problem...