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.
Asked
Active
Viewed 108 times
0
-
May be there are some non printable characters in your source for which it might be duplicating – Mayukh Bhattacharya Apr 21 '22 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 ! – satish mhatre Apr 21 '22 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? – Mayukh Bhattacharya Apr 21 '22 at 16:13
-
yes the data imported from DBMS , What will be solution for this ? – satish mhatre Apr 22 '22 at 07:23
-
Use `SUBSTITUTE()` Function to substitute `CHAR(160)` with `""` in your source for the specific column. – Mayukh Bhattacharya Apr 22 '22 at 17:04