0

enter image description here

In Excel, I'm getting duplicate values one with a check and one with unchecked when I create a pivot table.(see the attached excel screen)

Please help me with this.

Improve this question
5
  • May be there are some non printable characters in your source for which it might be duplicating Commented Apr 21, 2022 at 16:07
  • Oh did you see the screen that I attached? that contains special some special characters, however those characters are also present in other values and pivot was not repeating those ! Commented Apr 21, 2022 at 16:09
  • I meant to say non printable characters like like CHAR 160 127 etc, which cant be seen through naked eyes, we need to use a formula, have you imported the data from any DBMS or SAP or any ERP? Commented Apr 21, 2022 at 16:13
  • yes the data imported from DBMS , What will be solution for this ? Commented Apr 22, 2022 at 7:23
  • Use SUBSTITUTE() Function to substitute CHAR(160) with "" in your source for the specific column. Commented Apr 22, 2022 at 17:04
Related questions
1
Pivot Table contains extra rows
3
Why am I getting duplicate rows in Excel 2010 pivot table?
0
Avoiding duplicate rows in an EXCEL Pivot Table
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.