timbo3185
New Member
Hi, thanks for taking time to view my thread, i'm horrible at Excel and only understand the basics! so the struggle is Real!
So please help me, I have attached a file, it contains 4 sheets, but for now i'm only focusing on the sheet "Westall" and the sheet "Down"
The sheet named "Down" contains a timetable for the day and I have highlighted the cells that I am interested in. which are Rows 44 and 45.
I would like to basically transpose the time data from rows 44 and 45 into the "Westall"sheet column F5, however:
*Please note, as i'm writing this i notice there are one or 2 duplicated columns which i can fix later
so for example:
The data in the reference file looks like this:
and I would like the data to look like this: (sorry i can't resize the cell width in the thread)
Please let me know if there are any uncertainties cos i might have missed something here lol,
Thanks again for your help!
So please help me, I have attached a file, it contains 4 sheets, but for now i'm only focusing on the sheet "Westall" and the sheet "Down"
The sheet named "Down" contains a timetable for the day and I have highlighted the cells that I am interested in. which are Rows 44 and 45.
I would like to basically transpose the time data from rows 44 and 45 into the "Westall"sheet column F5, however:
- I want to avoid blank cells, &
- cells that contain ". . . . ."
- only contain times.
- contain the time that is displayed in the column, regardless if it's in row 44 or 45.
- times of the trains that do not stop at the station are denoted with an "*" so if possible that should be included, if not then i can find another solution.
- possibly have spaces inbetween cells.
*Please note, as i'm writing this i notice there are one or 2 duplicated columns which i can fix later
so for example:
The data in the reference file looks like this:
Westall | arr | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | . . . . . | ||||||||||
dep | . . | . . | . . | . . | 04 25 | . . | . . | . . | . . | 04 45 | . . | 05 05 | 05 05 | . . | . . | . . | 05 26 | . . | . . | . . | . . | 05 46 | 05 54 | 06 02 | 06 02 | . . | . . | 06 06 |
and I would like the data to look like this: (sorry i can't resize the cell width in the thread)
WTL |
04:25 |
04:45 |
05:05 |
05:26 |
05:46 |
05:54 |
06:02 |
06:06 |
Please let me know if there are any uncertainties cos i might have missed something here lol,
Thanks again for your help!