All data on pivot table rows

  • Thread starter Thread starter Paul Lautman
  • Start date Start date
P

Paul Lautman

The table below is an example of a pivot table query.

Is there some option that I can select that will cause each line to
contain all values (e.g. Row 2 Column 1 would contain 16/03 and Row 2
Column 2 would contain Mon, and so on).

16/03 Mon Admin 0.4
C2000 0.6
Dale 8.3
Tue Dale 7.5
Wed Admin 0.9
Dale 7.5
Thu ACM 0.5
Dale 8.5
Fri ACM 1
Admin 1
Dale 6.1
 
The row headings show once in a Pivot Table, and you can't force them to
repeat.

You could create a copy of the table, and fill the blanks:

1. Copy the Pivot Table cells to another location
2. Select the cells in the row heading columns of the Pivot Table copy
3. Choose Edit>Go To, click Special
4. Choose Blanks, click OK
5. Type an equal sign, then press the Up arrow key on the keyboard.
6. Hold the Ctrl key, and Press Enter.
7. Copy all the cells in the Pivot Table copy
8. Choose Edit>Paste Special, Values, click OK
 
Back
Top