| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table not sorting correctly
In column A I have several of the same names listed more than once spelled
exactly the same but when these line are pulled into a pivot table each is displayed seperately. I followed the same exact procedure for this table as I have for the others that I displayed correctly. What causes those lines to be displayed on separate lines? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Table not sorting correctly
Perhaps some of the entries have space characters at the end, and others
don't. Marian wrote: In column A I have several of the same names listed more than once spelled exactly the same but when these line are pulled into a pivot table each is displayed seperately. I followed the same exact procedure for this table as I have for the others that I displayed correctly. What causes those lines to be displayed on separate lines? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
| Sorting pivot table drop-down | Excel Discussion (Misc queries) | |||
Linear Mode
