Hi, I have been able to normalise imported data which is in the form as in the table below (the number of actual Date columns goes up to 30 or so)
ID Date1 Date2 Date3 Date4 Date5 Date6 etc
123 15-Feb-11 28-Feb-11 03-May-11 17-Jun-11
234 02-Apr-11...