Excel - Data Cleaning

%3CLINGO-SUB%20id%3D%22lingo-sub-1995065%22%20slang%3D%22en-US%22%3EExcel%20-%20Data%20Cleaning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1995065%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%20before%20I%20do%20data%20analysis%20using%20Excel%20I%20first%20clean%20the%20data.%20I%20did%20clean%20the%20data%20and%20then%20used%20the%20pivot%20table%20function.%20But%20for%20some%20reason%2C%20Female%20is%20repeating%20twice.%20I%20did%20check%20my%20excel%20spreadsheet%20to%20make%20sure%20female%20is%20mentioned%20twice%20on%20my%20spreadsheet.%20Can%20someone%20please%20help%20me%3F%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20the%20screenshot%20for%20everyone's%20reference%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3EAjay%20Vaidya%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1995065%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1995098%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Data%20Cleaning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1995098%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F904261%22%20target%3D%22_blank%22%3E%40ajayvaidya%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheck%20carefully%20whether%20there%20is%20a%20space%20after%20the%20word%20Female%20in%20some%20of%20the%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@ajayvaidya 

Check carefully whether there is a space after the word Female in some of the cells.

@ajayvaidya 

In addition, if source data is copy/pasted from Web that could be other non-printable characters inside. Not only space.