Pivot Table showing 2 sectors

[mSolver]

I have a Pivot Table from a huge sheet of data. Under the Sector header in Pivot Table, it shows the SAME sector as separate fields, even though I already checked each cell in the ORIGINAL table and they are IDENTICAL (i.e. no spaces, no symbols etc). How can I fix this? Have already rebuilt/refreshed it but the Pivot still shows as 2 sectors.

 

[Muhammad_Usman]

Share your complete data then it would be better to under stand

 

[RoryA]

They cannot be identical then. How exactly did you check them?