Repeated same data in pivot table.

[pradeepbmw]

hi

while using pivot table the same data is being repeated twice and thrice.Attached sample for reference with highlighted.

Thank you in advance.

 

[Shteven]

Hello pradeepbmw.

I looked at your data, and the reason why duplicates exist in the pivot is because there are extra spaces in your source data. Excel will consider "TEXT" a different value than "TEXT " (note the space) when creating your pivot table. You would need to cleanup your source data to remove the duplicates from the pivot.

 

[pradeepbmw]

hi shteven,

thank you for your reply , can u plz help me how to clean up and remove duplicates,i tried for find and replace but it didnt actually worked.

 

[NARAYANK991]

Hi ,

One way is to use formulae ; I have used them in column D , and the resulting pivot table is in columns L and M.

Narayan

 

[pradeepbmw]

hi

thank you , the problem is solved thank you again, is there any alternate , the formula is too long and confusing .