I have a sheet, where there is a list of times in Col. C.
What I want is for it to be split into different rows & also the relevant order number & name to be copied with the rows. Resulting look:
I have about a 300 rows of orders to do this way. Right now I'm doing it manually and its taking ages. And what I posted here is only a part of the process.
Here is the sample spreadsheet: https://docs.google.com/spreadsheets/d/1VENgvRAdBaAC28lpJ5a2QvD5KtnD-S3dx5rUELzvGCM/edit?usp=sharing