You're welcome! Thanks for letting me know that it helped.

Eileen wrote:
Debra,
Thank you for the post. It helped and I was able to get rid of a double
listing in my pivot table.
Peace -
Eileen

"Debra Dalgleish" wrote:


Maybe some of the items have space characters at the end, in the source
table, and others don't.

markh wrote:

I've have used pivot tables quite often, but for some unknown reason this
time I cannot get like items to combine from the soure excel sheet.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html