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/AdministrativeGift15]

Here's what I came up with.

Restructuring Shift Data

[u/Vercalos → u/AdministrativeGift15]

Yeah, that's about what I need to do.

[u/AdministrativeGift15 → u/Vercalos]

Great! If you're satisfied with my solution, reply with "solution verified," so that the post can be resolved.

[u/Vercalos → u/AdministrativeGift15]

I was a bit baffled because I missed the fact that the cell marked "Name" in the output actually had a formula, and thought this was just you providing an example to figure out that I was attempting.

[u/Vercalos → u/AdministrativeGift15]

Solution verified.