Rick: That worked fabulously! Ironically, it also highlighted some
quirks in my dataset. Most of the time my data only has one series of
years, but every so often there's more than one series of years.
Here's an example with the results of your VB code in column C

Col A Col B Col C
11.7102R 1979 "1979 , 1980 , 1981 , 1982 , 1983 , 1984 , 1985"
11.7102R 1980
11.7102R 1981
11.7102R 1982
11.7102R 1983
11.7102R 1984
11.7102R 1985
12.3101G 1966 "1966 , 1967 , 1968 , 1969 , 1970 , 1971 , 1972 , 1973 ,
1974 , 1975 , 1968 , 1969 , 1970 , 1971 , 1971 , 1972 , 1973 , 1974"
12.3101G 1967
12.3101G 1968
12.3101G 1969
12.3101G 1970
12.3101G 1971
12.3101G 1972
12.3101G 1973
12.3101G 1974
12.3101G 1975
12.3101G 1968
12.3101G 1969
12.3101G 1970
12.3101G 1971
12.3101G 1971
12.3101G 1972
12.3101G 1973
12.3101G 1974

You can see that 11.7102R only has one series of years, but 12.3101g
has three different series of years. I need the years pulled out each
time the series of years starts over. I.e. for 12.3101g 1966 though
75 and 12.3101g for 1968-71 and 12.3101g for 71-74