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 for consultations.
They've added three additional responses, that fall under the "agree" category, however when they generated the pivot table, it's generating a separate row for "Agree". So say there are 15 agrees, 14 disagrees, 4 no responses and 3 agrees.
Is there a way to roll these 3 extraneous agrees into the larger set of agrees? I have a vague sense that it requires refreshing the "table" based on when I had a similar issue, but I can't remember exactly sorry.
Thank you.
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.