Apr 16 2019 02:38 AM
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.
Jan 24 2023 06:21 PM
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