View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mhead mhead is offline
external usenet poster
 
Posts: 1
Default repeat row labels in pivot table

I am working on a project where I'll be using data from a pivot table. I want
the row labels to repeat on each line in the tabular format. So rather than
it looking like this:

East
January
February
West
January
February

I want it to look like this:
East January
East February
West January
West February

Any ideas on how to do this? I tried everything I could find and can't get
it to work.