Forum Discussion
PivotTable issue with duplicating field
Hello, So a colleague of mine has set-up a pivot table for a consultation, with the entries of agree and disagree (and not answered). They've drawn this from imported data from a website we use f...
Please check in source data if category have the same text in imported data and manually added records. Text from web could include non-printable characters. Even if both looks like "Agree" that could be different texts.
You may check in any empty cell like =B5=B25 if it returns TRUE or FALSE. Assuming in B5 is Agree from web and in B25 manually added.
