Forum Discussion

JM_ms1585's avatar
JM_ms1585
Copper Contributor
Jul 12, 2024

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.

  • JM_ms1585 

    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.

Resources