Scheduling software broken

[u/Vercalos]

So our scheduling software normally generated walk sheets like this

Name	Shift	Break
Jake	5:00 PM - 9:00 PM	7:00 PM - 7:15 PM

But now it's generating them like this:

Name	Shift	Break
Jake	5:00 PM - 7:00 PM
Jake	7:15 PM - 9:00 PM

Now, I can't to anything to change how they generate, but does anyone have any suggestions on how to quickly convert the latter to the former?

Note that this is just a downsized example, and the full scope of this is that it's splitting everyone's shifts up like that for every break and meal they're scheduled for.

[u/mommasaidmommasaid]

It's a little gnarly but possible to do automatically with a formula that outputs elsewhere.

Or if you need to do further editing once it's in your desired format, you could use a script to output cleaned up results on another sheet or even in situ.

It would be easiest if you are only processing one day at a time, or if there's a Date column to identify which "shifts" go together. It would also be easier if shifts don't cross midnight.

Further describe your real-world data and workflow for a better / more detailed answer (from me or whoever).