Is there a way to get the pivot table to automatically repeat the names in
the outer row fields? This way one could use the resulting pivot table as a
database. Normally you have to manually copy the names to the blank cells
below the name in the outer row fields. In the below example I would like
EAST to show up in every cell below it, same with WEST

Region Salesperson
EAST Buchanan
Davolio
Dodsworth
Suyama
WEST Buchanan
Davolio