Dear all I have the following cell matrix
A={
1 'SLO' ' ' 1 'SLO' ' ' 1 'SLO' 'JF 2009' 1 'SLO' 'MA 2009' 1 'SLO' 'MJ 2009' 1 'SLO' 'JA 2009' 1 'SLO' 'SO 2009' 1 'SLO' 'ND 2009' 1 'SLO' 'JF 2010' 1 'SLO' 'MA 2010' 1 'SLO' 'MJ 2010' 1 'SLO' 'JA 2010' 1 'SLO' 'SO 2010' 1 'SLO' 'ND 2010' 1 'SLO' 'JF 2011' 1 'SLO' 'MA 2011' 1 'SLO' 'MJ 2011' 1 'SLO' 'JA 2011' 2 'SLO' ' ' 2 'SLO' ' ' 2 'SLO' 'JF 2009' 2 'SLO' 'MA 2009' 2 'SLO' 'MJ 2009' 2 'SLO' 'JA 2009' 2 'SLO' 'SO 2009' 2 'SLO' 'ND 2009' 2 'SLO' 'JF 2010' 2 'SLO' 'MA 2010' 2 'SLO' 'MJ 2010' 2 'SLO' 'JA 2010' 2 'SLO' 'SO 2010' 2 'SLO' 'ND 2010' 2 'SLO' 'JF 2011' 2 'SLO' 'MA 2011' 2 'SLO' 'MJ 2011' 2 'SLO' 'JA 2011' }
As you can see I have bimontly data. I want to modify the last column so as to have months like
Amodified={ 1 'SLO' ' ' 1 'SLO' ' ' 1 'SLO' 'J 2009' 1 'SLO' 'F 2009' 1 'SLO' 'M 2009' 1 'SLO' 'A 2009' 1 'SLO' 'M 2009' 1 'SLO' 'J 2009' 1 'SLO' 'J 2010' }
and so forth
Is there any "clever code to do that?
NOte that the fist column represents the individual. In my real matrix I have 30000 individuals.
thanks in advance
Best Answer