View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Pivot Table Display

Cisco Kid wrote:
If you have more than one item in the "Row" section of a pivot table the
display only shows the label in the first column once if there is more than
one value in the second item. Is there a way to get the pivot table to
display the value in the first item and not leave blanks? I want to be able
to use the results like a data table.


Hi Cisco,

I wrote in this group regarding a work-around a few days ago:

http://preview.tinyurl.com/6f3um2