Schedule tracker - just need to return a yes if anyone of multiple people can do time/day

[leon_mc]

Hi,

Any help is appreciated. I have attached some sample data.

From Columns A to P, i have a list of dates and then a timetable where various people have advised they can be available at certain time blocks. Each different row on the same date represents a different person that has given their availability for that day.

I wish to consolidate this information into one master row per day and collapse the 'Yes' responses into a single row format. So as long as that time slot is marked as 'Yes' by anyone on that date, I wish that to be entered into the condensed row.

I am looking for this result to be entered into rows T to AH.

I have included a sample row as an example - T4:AH4.

It seems pretty simple, I just haven't had to consolidate data in this fashion previously so am at a loss as to how to proceed on this.

Thanks in advance!