📣 Is this even possible?!! Convert one schedule to another

Hello Everyone!

I am a stage manager for a live entertainment production. I have implemented a new scheduling system called Virtual Callboard and am hitting a few obstacles with trying to convert the old system to the new.

When I create a draft schedule to send to managers to review before publishing it to the entire company, the managers have a current spreadsheet format that they prefer. Although, Virtual Callboard does export the draft schedule to a csv, the managers are not thrilled with the layout and would like it to look more similar to what they are used to.

Is there anyway to create a macro (or anything else) that would convert the Schedule Draft Export to the Schedule Target Layout? I've attached both examples. The schedule data is not the same in both but it give you an idea of the layout.

I was wondering if it's possible to separate the schedule into sections according to date, title each section with the corresponding date, and clean up the date/time format.

Any help/suggestions/comments would be immensely appreciated!

Thanks... David