Table to Database layout
 

Hi Everyone,

Does anybody have any code, or can point me in the right direction, to
manipulate data as per example below. This is only an extract of the
data. The final table will have approx 30 locations, 7 days and 5
sessions a day.

START WITH THIS TABLE

Location Mon Mon Mon Mon Mon Mon Tue Tue Tue Tue Tue Tue
Session 1 Session 1 Session 2 Session 2 Session 3 Session 3 Session
1 Session 1 Session 2 Session 2 Session 3 Session 3
Start End Start End Start End Start End Start End Start End
Room 1 9.00 10.00 12.00 14.00 16.00 17.00 9.00 10.30 14.00 16.00
Room 2 10.00 11.00 13.00 15.00 14.00 16.00 18.00 21.00

END UP WITH THIS TABLE

Visit No Day Session Location Start End
1 Monday Session 1 Room1 9.00 10.00
2 Monday Session 1 Room2 10.00 11.00
3 Monday Session 2 Room1 12.00 14.00
4 Monday Session 2 Room2 13.00 15.00
5 Monday Session 3 Room1 16.00 17.00
1 Tue Session 1 Room 1 10.30 14.00
2 Tue Session 1 Room2 14.00 16.00
3 Tue Session 2 Room1 14.00 16.00
4 Tue Session 2 Room2 18.00 21.00

I hope you make sense of the layouts once posted to the newsgroup.

Any help gratefully appreciated

Michael Beckinsale