Why can't I group multiple years in my pivot table? I want to group years 1980-1995 and 1995 -2005. I tried doing a manual grouping, but it just keeps bringing up the automatic grouping. Then I tried changing all the years to numbers and do a number grouping, but it still treated it as years. Help me!