• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table


New Member
I have a spreadsheet of data and one of the columns on that spreadsheet is the month. I enter the month data as January, February...etc. so I just do the month name. I do this so when I create my pivot table, I can look for data for that particular month. When I drag the month over to the pivot table, it lists two Octobers and two Novembers. Then I have to look at both months on the pivot table instead of that one month that I have to get the data. Does that make sense? Does anyone know why the pivot table list two entries of the same month?

Thanks for your help.


Excel Ninja
Staff member

Pivot tables are both case sensitive and also check for spaces at the beginning and end of the words "January " is different to "January" and " January"