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.