Home

Unable to remove Repeat Item Labels in a Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-459397%22%20slang%3D%22en-US%22%3EUnable%20to%20remove%20Repeat%20Item%20Labels%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-459397%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20In%20my%20Data%20sheet%20the%20first%20column%20is%20made%20up%20of%20different%20Countries.%20In%20my%20Pivot%20table%20certain%20countries%20appear%20multiple%20times%20when%20I%20select%20the%20%22Country%22%20field%20and%20add%20it%20to%20either%20rows%20or%20columns.%26nbsp%3B%20I%20have%20followed%20the%20advice%20of%20this%20support%20page%2C%20but%20it%20doesn't%20help%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Frepeat-item-labels-in-a-pivottable-882bdb55-9cdc-4d8d-b531-8e96e41dea31%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Frepeat-item-labels-in-a-pivottable-882bdb55-9cdc-4d8d-b531-8e96e41dea31%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20also%20happening%20to%20other%20data%20sets%20in%20the%20same%20worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20providing%20insights%20on%20how%20to%20rectify%20this%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-459397%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
KD0905F
Occasional Visitor

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

 

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

Thanks for providing insights on how to rectify this issue. 

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies