Hi - my pivot table groups rows like this (i.e. only showing the name Jones
for one of the two rows for this name):

Name City
Smith London
Jones Edinburgh
(blank)
Clarke Paris

I'd like the names column to be more explicit, i.e. what I'd like to see (to
be able to use Excel's database/list functions) is:

Name City
Smith London
Jones Edinburgh
Jones (blank)
Clarke Paris

Any ideas?

Thanks.