Forum Discussion
Duplicate groups in pivot table
I have a simple table with three groups, and I'm trying to tally how many males vs females. I'm getting the following: Count of Subject ID Column Labels Row Labels INR R Z Gr...
The assumption that there is a space may be correct for the "F" , however for the "M" there is a value in the 2 rows.
I do not prefer to provide an answer without a sample data in Excel to be more accurate!
Thanks
Nabil Mourad
The sample within text is copy/pasted from Excel file. If you copy/paste it back from post to Excel file you'll see extra spaces.
It did, in fact, turn out to be a trailing space causing the problem. I thought I had done a correct global replacement, but even doing that, I ended up finding the individual rows causing the problems from the Pivot Table, and correcting the trailing space.
Thanks for the quick replies.
