Rearranging timetable data

[tessda]

Hi Guys and girls,

In September 2014 Richard Buttrey assisted me in solving a similar but less"complicated" problem I had . Thread name "extracting/transposing" sheet data.

I have a new challenge with a more complicated timetable (file "New Timetable" attached)in the attached file with two worksheets Zone 3 to Pta (this is the example of how the timetables look like) and Solution (the format in which I now need it - i only included 3lines as example). The timetables can contain more columns as well as rows.

What is important (and I don't know whether it is possible) I need the name on the tab as part of the solution if possible.

I attach the solution which Richard provided earlier for reference purposes with file name "timetable".

I need to do this for approximately 50 timetables of a similar format.

Your guidance and assistance will be appreciated.

Regards

Danie