View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Geoff B Geoff B is offline
external usenet poster
 
Posts: 7
Default Office 2007 Pivot Table Display format - Show row headings in each

Is it possible to show the row headings against each line of data in a pivot
table

Currently shows
Row Label 1
Row Label 2
Value
Value
Value

What I would like to see is
Row Label 1 Row Label 2 Value
Row Label 1 Row Label 2 Value
Row Label 1 Row Label 2 Value

I am trying to avoid a lot of cust and paste work when I transpose this data
to another file from the pivot table. I know this output format can be
obtained from Sort & Subtotal on the raw data but I was hoping if possible to
get this from the pivot table. Any and all suggestions welcome. Thankyou
for your time. Geoff