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.