Hi, I would like to change a dataset that looks like this: ID Date1 Date2 Date3 Date4 1 01/05/2014 . . 02/02/2014 2 . . 03/08/2013 . into this: ID NewDate1 NewDate2 NewDate3 etc. 1 01/05/2014 02/02/2014 . 2 03/08/2013 I'm not worried about the order of the dates in the particular row, would just like them to 'fill' from the left. Is this something I can do with an array / retain? Thanks
... View more