When you create a pivot and the same "Name" is in the pivot, it sums it...how can I display all items?
Example, on this screenshot, United Bank is on row 9....but 10,11,and 12 are blank, because those are also United Bank....how can I change the pivot to United Bank shows on rows, 9-12?222.JPG
I am in Excel 2010
Bookmarks