Hi,

Using Pivot Tables, how do I count unique items from different columns?
For instance:

FRUIT 1 FRUIT 2
apple pear
pear pear
apple pear
banana peach
peach pear

DESIRED RESULT:
apple 2
banana 1
pear 5
peach 2


I have tried Pivot Tables
Row: FRUIT 1
Sum Values: FRUIT 1, FRUIT 2

However, this results in 2 columns of Fruit 1 counts.