View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NBurton NBurton is offline
external usenet poster
 
Posts: 2
Default Pivot table - don't group names

I have created an office directory using pivot tables. I have a couple of
people with the same first name and in the pivot report, it groups them by
first name. I need to have each person listed separately; therefore, instead
of one "amy" with 2 last names, I need each line to show "amy" "last name".