Hi
I have a pivot table that takes from yearly sheets the following
Rider, Nat (Nationality), Total

On Each sheet is a set of results with a column to Total them (passed
to the pivot)
EG
Rider, Nat, Eur, Slo, GB, PL, DK, Total

I spoted in the pivot table two riders who had slightly different
spellings, so instead of one entry there were two of course.
I went back to the relevant sheet, corrected the spelling, and
regenerated the pivot

However, I now have a correct entry (spelling) in the pivot, but two
additional entries showing correct and incorrect names but no totals
and the row has 'spread' to look like:

Bob Smith, PL
Eur
Slo
GB
PL
DK
(They should all line up under PL in Column B)

I can't seem to correct it.
Any ideas welcomed!

Thanks
Neil