Transform and reorganize data

[konnursrikant]

I want to transform this data into two columns as Day 1 and Day 2 , starting with the day 1 first value and end day 1 for 24 hours later (2pm-2pm next day as day 1) and next 24 values as day 2. The start time for Day 1 keeps changing for different scenarios. I want a dynamic formula to Setup day 1 and day 2. I have 200+ such sheets. So a quick and easy process is much appreciated.

 

[Fluff]

Duplicate to: Reorder the 3 column data into 2 columns of 24 rows

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.