If the Item numbers are entered differently in the source table, they'll
show up as different items in the pivot table. Perhaps some of the item
numbers have spaces at the end, and others don't.

To limit the entries, you could use a data validation list in the source
data table. There are instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html

Kerry wrote:
I have a simple pivot table referencing three columns of data: store name,
item number, quantity sold. When I convert this to a pivot table, showing
store name and item number as X and Y axis, and quantity sold as the data, I
get duplications for the item numbers. The caveat is that it doesn't
duplicate exactly, it looks like this:
Item #1 Item #1 Item #2 Item #2 Item #3 Item #3
Store A 55 66 77
Store B 44 88 99
Store C 33 22
33

What can I do to get all my data to show just one column for each item
number? Since I only have three columns of data that I am referencing, I
don't understand why the Pivot table is splitting this data.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html