What will you do with duplicate data in pivot table?

AnswerBot
1y
Remove duplicate data in pivot tableIdentify the duplicate data in the pivot tableDelete or filter out the duplicate dataRefresh the pivot table to reflect the changesUse conditional formatting to hig...
see more
Anonymous
1y

The pivot table will automatically remove anyn dupliate in our data

Anonymous
1y

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.

Anonymous
1y

I dont know,How can happen that.

Anonymous
1y

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

saugata pal
1y

Before pivot, remove duplicate

Anonymous
1y

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.

Add answer anonymously...
TCS Process Associate Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
55 L+

Reviews

5 L+

Interviews

2 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2023 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Hello, Guest
Contribute to help millions!
Write a review
Share interview
Contribute salary
Add office photos
Add office benefits