Forum Discussion

KD0905F's avatar
KD0905F
Copper Contributor
Apr 16, 2019

Unable to remove Repeat Item Labels in a Pivot Table

Hello, In my Data sheet the first column is made up of different Countries. In my Pivot table certain countries appear multiple times when I select the "Country" field and add it to either rows or columns.  I have followed the advice of this support page, but it doesn't help : https://support.office.com/en-us/article/repeat-item-labels-in-a-pivottable-882bdb55-9cdc-4d8d-b531-8e96e41dea31

 

This is also happening to other data sets in the same worksheet. 

Thanks for providing insights on how to rectify this issue. 

 

1 Reply

  • Dathill's avatar
    Dathill
    Copper Contributor

    Use this 

    https://www.pivot-table.com/2013/09/11/duplicate-items-appear-in-pivot-table/

     

    your data likely has a space after it 
    KD0905F 

Resources