View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richhall[_2_] Richhall[_2_] is offline
external usenet poster
 
Posts: 41
Default Pivot Tables to summarise a column in one row?

I have a column with a list of names in, and then in the other two
columns a list of attriubutes for that person. The number of
attributes could change, how can i simply get a single name entry with
the attributes listed in a row.

i.e

Name Subject Grade

John English A
Maths B
Jane English B
German C
Maths B

Would be:


John English A Maths B
Jane English B German C Maths B

Cheers

Rich