Listing dates with corresponding row values in order in columns from oldest to newest

Greetings,

I need to rearrange my data somehow so that they line up in two columns with values from oldest down to newest. The data are dated and each date may have multiple values in corresponding rows. Which is the most efficient way to line up the dates with each value in sequential order down two columns?

In the sheet example, rows 5 through 8 are dated and each row has several values listed horizontally for each date. How can they be rearranged so that they line up as shown in column W and X?

Thank you Alan,

This seems to be a solution. I'm not familiar with Power Query. Allow me to get acquainted with this process in a bit.
BTW, in the attached file, why is there a value of 8 in the B2 cell? This is not a listed value.

Alan,

Did some studying of Power Query and played around with it. Nifty!
I was able to make the necessary corrections by removing the D & E columns before unpivoting the data columns. I like this!

I did notice that the sheet2 file does not refresh when new data is entered in the TimeOut file table unless I manually refresh the file.
Quick question, is there a way for this sheet to automatically refresh wnenever new data is entered on the table?

Thanks bunches!

Most likely will use this method but I'm wondering if there are other ways to have these columns created on another sheet so I have just the dates in one column and the data in the adjacent column?

My concern is for a method that will be dynamic enough to allow for new data entries to be entered and automatically appended to the list.

Again, thanks bunches for your help and suggestions. This is going to make a difference!