Pivot Table Showing Duplicate Names

**realniceguy5000** · 05-13-2009, 03:05 PM

Hi,
When I make a pivot table I wanted to know why it is showing duplicate names. Here is an example workbook below. It should group all the same names together. However it isn't doing so. Anyway around this problem?

Thank You, Mike

**martindwilson** · 05-13-2009, 07:37 PM

some of the names have spaces so they are considered different
you need to delete trailing paces e.g.
Al 13 100 1412 18 16.5 85.57575758 6.060606061 0.787878788
"AL" IS ACTUALLY "AL "
first try select column
data/text to columns
fixed width then just click finish
refresh pivot
failing that
in a spare column put in row 2 =trim(a2)
drag to end
then copy /paste special/ values back over original . delete col with formulas. then refresh pivot.

**realniceguy5000** · 05-14-2009, 07:49 AM

Originally Posted by martindwilson

some of the names have spaces so they are considered different
you need to delete trailing paces e.g.
Al 13 100 1412 18 16.5 85.57575758 6.060606061 0.787878788
"AL" IS ACTUALLY "AL "
first try select column
data/text to columns
fixed width then just click finish
refresh pivot
failing that
in a spare column put in row 2 =trim(a2)
drag to end
then copy /paste special/ values back over original . delete col with formulas. then refresh pivot.

Oh I see now, Working much better now. Thank You for your help!!!!

Mike