Like items will not combine in a pivot table.
 

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.

Like items will not combine in a pivot table.
 

You've given us next to nothing to go on to deduce what the problem is.

If you check the LEN() of each item you *think* should combine, do you get a
difference?



"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.

Like items will not combine in a pivot table.
 

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

Like items will not combine in a pivot table.
 

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

Like items will not combine in a pivot table.
 

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