'Merge & Center' to 'Centre Across Selection' as code with Data Splitting.

I got help from this forum before to convert 'Merge across' alignment to 'Centre across selection' and as the following code gives output. The previous code needs a little modification. For example, merge cells always have three data sets separated by spaces or line breaks. These three data have to be split and allocated vertically to three cells, and then the cells have to be converted to the output as given by the following code.?*
Furthermore, this code works with 9 pages of data, I want it to work with up to 15 pages of data.

I don't know if my request is appropriate or if it is consistent with the forum rules. If anyone can help me with this, I would be very grateful.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Your work was excellent. You did it very quickly and with a lot of care. I am grateful to you.
I would be grateful if you could provide solutions to the following issues if you ever have free time.

1) Column 'D' (Room) and column 'E' (Short Name) of the 'Output' sheet will be swapped.

2) If there is a class in two periods, for example, 'Sunday' 08:45-09:30 and 09:30-10:15, these two periods are a single class, so I only want the start and end time of that period in the output sheet as single time duration, for example, 08:45-10:15.
You have done this work earlier through the code below.

3) Additionally, in the output sheet, I want "Group" and "Semester" according to the routine of the 'Routine(Input)' sheet. This is my humble request, which was not asked in the original question.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

the above does not require cells to be unmerged.

I have left the other (old) macros in the w/book (as a fallback!)

and please do not quote code in any replies as it is only "clutter".

You're very welcome. Thank you for the feedback and rep.