Dec 16 2020 10:53 AM
Hi Everyone, before I do data analysis using Excel I first clean the data. I did clean the data and then used the pivot table function. But for some reason, Female is repeating twice. I did check my excel spreadsheet to make sure female is mentioned twice on my spreadsheet. Can someone please help me?
Attached is the screenshot for everyone's reference
Thanks in advance
Ajay Vaidya
Dec 16 2020 11:10 AM
Check carefully whether there is a space after the word Female in some of the cells.
Dec 17 2020 03:21 AM
In addition, if source data is copy/pasted from Web that could be other non-printable characters inside. Not only space.