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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,118,908
Messages
5,574,969
Members
412,630
Latest member
Eireangel
Top