+ Reply to Thread
Results 1 to 2 of 2

Pivot table function adding spaces in cells

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Pivot table function adding spaces in cells

    I owe a document to the CEO, today. I am creating a pivot table with sizes,types and quantities of bolts. There are repititious sizes and the pivot table will allow me to consolidate.
    When I "Insert" pivot table it is for some reason putting a space in front of some of the sizes, so when I filter, it shows the same category twice, because one of the sizes has this space and is recognized as different.

    So, I went to the original table and made certain all spaces were gone in front of all cells. I tried again, and I now know that the spaces are being added by the program, or at least it appears that way.

    I need this data consolidated. notice the 2"1/4 and A325 alignment, below. All of this size should be 1 line item

    7/8" 194 100 204 192 328 22
    DIA 194 192 22
    *A325 194 22
    *2"1/4 194 22
    *A325* 192
    2"1/4 192
    DIA* 100 204 328
    A325 100 204 328
    *2"1/4 100 204 328

    Should be (or similar):
    7"8 100 204 192 328 22
    DIA 100 204 192 328 22
    A325 100 204 192 328 22
    2"1/4 194 100 204 192 328 22

    Well, ok, the preview does not look like it should but the asteriks represent the additional spaces that I am not putting in.
    Last edited by Airskip2012; 09-07-2012 at 04:19 PM. Reason: add attachment

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    Essex, UK
    MS-Off Ver

    Re: Pivot table function adding spaces in cells

    PT don't usually add spaces.
    Are you sure the original data is clean and does not contain the spaces. You can quickly check by using Filter and then checking the entries in the dropdown list. Or use a copy of the data and Remove duplicates.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1