i have two columns one with years in the other with seasons, problem is winter goes over a change in years. what i want to be able to produce is WINTER 2002/2003.(i can only get it as winter 2002 and winter 2003)
Year Season
2002 Winter
2002 Winter
2003 Winter
2003 Winter
I can concatenate the other seasons, but i need help on this one. there is also alot of data.
Thanks
Year Season
2002 Winter
2002 Winter
2003 Winter
2003 Winter
I can concatenate the other seasons, but i need help on this one. there is also alot of data.
Thanks