View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default repeating names in row fields of a pivot table

Not and keep it a pivottable.

You could convert it to values (select, edit|copy, edit|paste special|values)
(or do the same thing against a copy)

Then use some of the techniques at Debra Dalgleish's site to fill the empty
cells:
http://www.contextures.com/xlDataEntry02.html

Jack N wrote:

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


--

Dave Peterson