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!

[TimN]

Something like this?

[AndrewDMerrill · Accepted solution]

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

[walkingonformulas]

Thank you both, that helps a lot!