| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I combine two pivot table? | Excel Worksheet Functions | |||
| Is it possible to combine two worsheets into one Pivot Table? | Excel Worksheet Functions | |||
| Pivot table items | Excel Discussion (Misc queries) | |||
| How do I combine four data items into one in a Pivot Table? | Excel Discussion (Misc queries) | |||
| Can I combine two worksheets into one pivot table? | Excel Worksheet Functions | |||
Linear Mode
