Is there a way to convert from matrix A (5×3) where the first element is year and the second element is month (no day element) to a serial number in matrix B (5×2)?
A=...[2013 12 0.6;2013 12 0.8;2014 1 0.5;2014 2 0.1;2014 2 0.7]
Answer should be:
B=...[serial1 0.6;serial1 0.8;serial2 0.5;serial3 0.1;serial3 0.7]
Where serial1 is a number for 'Dec-2013' and so on. Thanks
Best Answer