Need the intervals from all date stacked on top of one another, not side by side

Hi - can you please attach your file? And exactly what you're looking for

Hi Mike, its been uploaded. in the 'Intervals side by side' tab, i need the data from the different dates stacked on top of each other rather than being side by side. I've attached a capture of another file where this has been done. Note that the date 7/6 rolls right into 7/7 as you scroll down.Attachment 686893

Hi I got your spreadsheet but the other attachment keeps saying invalid attachment

I added it to the main post above

OK - I found a macro that will do some of it, so now your file is a macro-enabled file.

I created a new tab just to try it out and did 1st two dates for you.
So this part is a pain (sorry) I copied the Interval column (times) into column B and put the 1st date 5/4 in column A and copied it down. Then I copied the interval again and put the next date and copied that down. Afraid you will have to do that for the rest - unless you can come up with another way (sorry)

Now for the macro part:
Go to the View Tab
Click on Macro
You will see one named StackColumns
Click Run
A box pops up called Select Columns
Put in your columns (starting at line 2) ie $b$2:$c$49
Click OK
Then box pops up Select a cell to place result
I clicked on the Intervals Stacked Tab and selected C1

Hope that is what you are looking for.

I'll give it a shot, thank you much for the help!