Pivot Table not populating cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a set of data which I need to put into a PT: Level 1 is Surname and
level 2 is First Name. I've sorted it within the PT by Surname then First
name. I have 15 instances of the name Jones. When the PT is produced it
only shows one instance of th word Jones and then the rest of the lines below
(ie the other 14) have no data. The next column to the right has all 15
First names but the only one with Jones next to it, is the first one.

How can I get my PT to show ALL surnames next to all the first names please?

Thanks in advance,

AW
 
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat.

To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location, and fill in the blanks,
using the technique shown here:

http://www.contextures.com/xlDataEntry02.html
 
Back
Top