Grouping data when importing to Pivot Table

[Gordon]

I am importing data from a SQL database into a pivot
table. I am sorting the data on a users last name.

The problem is the grouping. The data comes into the
pivot table grouped by last name ok, however, the last
name is only listed once for every multiple instance of a
different users first name. ie: column 1 row 1 lists
Adams. If there are five people with the last name
Adams, then rows 2 thru 5 are blank and column 2 row 1
thru 5 shows the first name. See below.

Adams Bob
Charlie
Greg
Paul
Steve

Is there a way to not make the pivot table import group
the names in this way and to make it list the last name
for every instance of a first name. See below

Adams Bob
Adams Charlie
Adams Greg
Adams Paul
Adams Steve



Thanks in advance.
Gordon

 

[Debra Dalgleish]

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

To print the table with a heading on each row, you can create a copy of
the table, and fill the blanks:

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