I have created a pivot with data fields that include customer, city and
country. When there is a duplicate name and city with two different
countries, the second entry for the customer and city are blank. This creates
problems since I use these fields in formulas external to the pivot table.
Any ideas for how to "repeat" the customer and city name in the pivot?

Dave