I have a challenge with a public transport timetable (file "New Timetable" attached). In the attached file there are two tabs "Zone 3 to Pta" (this is an example of how the timetables currently look like) and "Solution" (the format in which I now need it - I only included 3 lines as example). The timetables can contain more columns as well as rows. As can be seen there are various numbers of "intermediate points with arrival times attached.
What is important (and I don't know whether it is possible) I need the name on the tab as part of the "Solution" as shown in Column A.
I need to do this for between 50 and 100 timetables of a similar format and by hand it will take days.
Is it possible to write a macro which will convert the info from the one format ("Zone 3 to Pta") to the new format as shown on "Solution"?
Your guidance and assistance will be appreciated.