Forum Discussion
Excel - Data Cleaning
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
2 Replies
In addition, if source data is copy/pasted from Web that could be other non-printable characters inside. Not only space.
Check carefully whether there is a space after the word Female in some of the cells.
