How do I show full detail of merged items in a pivot table?
 

I need to show the individual detail of items in a pivot table for use in
lookups etc afterwards, but the detail keeps getting summarised and I can
only work out how to merge the cells, not show detail for each one.

e.g. products have same name but different pack sizes, and it only shows the
name in one of the 2 cells