Search results

Thanks for your suggestion. Unfortunately I didn't explain the data type properly. The Hours fields in my example are meant to be numbers (of hours worked on that day), not times. I want to end up with a table like this. ID Date Hours 123 15-Feb-11 2 123 28-Feb-11 4 123...

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...