Office 2007 Pivot Table Display format - Show row headings in each


G

Geoff B

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
 
Ad

Advertisements

J

Joachim

Hallo Geoff,

The direct answer to your question is no. You cannot change the empty cells
in the label columns.

Possible workaround: Copy the pivot table as values and fill the empty
spaces with a simple formula:

1. Click the pivottable
2. Under PivotTable-Tools select Options tab
3. Click Select and select PivotTable
4. Copy the pivottable to the clipboard
5. In your new map right click - paste special - values and number formats
6. Select all cells from the top Label 1 to the last empty cell in the
first label column
7. Home tab-Edit group-select Goto-Empty Cells
8. Write formula "=E5" (assuming your top label is in E5, adjust as required)
9. Ctrl+Enter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top