Hi,
The information you get in the pivot table is correct in your original list
you have apple twice, before and after orange

"reza" wrote:

Hi all...

simple question about pivot table
i have 2 column
names fruit
reza apple
reza orange
reza apple

what i want to do, create pivot table with results
reza
apple 1
orange 1

but when i created that, the result is:
reza
apple 2
orange 1

thanks....