Pivot table not combining duplicate data

gittymoe

Board Regular
Joined
Apr 23, 2005
Messages
77
I have a large spreadsheet where in column "A" I have customer names that are duplicated many times and in column "B" I have product names that are also duplicated many times. (this is not my enitire spreadsheet but just the columns that I want to analyze). My problem is that when I run the pivot table the data in column b is sometimes duplicated in the pivot table. If you have any suggestions or ideas on how to fix this I would appreciate it.


Thank You,
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,118,435
Messages
5,572,085
Members
412,441
Latest member
kelethymos
Top