Remove duplicate data in pivot table

• Identify the duplicate data in the pivot table

• Delete or filter out the duplicate data

• Refresh the pivot table to reflect the changes

• Use conditional formatting to hig...read more

The pivot table will automatically remove anyn dupliate in our data

Pivot tables make it easy to count values in a data set. One way this feature can be used is to display duplicates. Also we can Refresh the pivot table and the duplicate items will disappear.

I dont know,How can happen that.

Right-click on your pivot table and choose Refresh to make the duplicate values appear.

Before pivot, remove duplicate

Hello Abhishek, I was working in Banking and Finance domain. Hence i feel you should reach out to someone working in IT domain because they can guide you better than me.