Transforming Data

walkingonformulas

Hello! I'm having trouble with the following:

I need a way to match the values in the "Date" field with the first row of data in the days of the week fields. Based off this match, I then want to display the respective hours under each date. It should look like this below:

Thanks for the help!

CoG

Here is an alternative Workflow that utilizes the sample input provided (if your needs are that specific):

Sample Workflow.yxmd