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 Pivot tables 2 row labels

Nope--not if you want to keep it a pivottable.

But you could convert to values (or copy|paste values in a different location),
then fill the blank cells with the value of the cell above it.

Debra Dalgleish's site has some tips:
http://contextures.com/xlDataEntry02.html

sdav wrote:

I am trying to create a pivot table and want to have sales rep names and
company as the rows. Is there a way to have the sales rep name repeat
everytime with the company instead of how it looks below? I am going to have
to use the output of the sheet to do a vlookup on another sheet and in this
format I can't make it work. Thanks!

Row Labels
Jane Doe
Company 1
John Doe
Company 2
Company 1
Company 3
Company 5


--

Dave Peterson