Excel Table, lookup, match, index, array ??

Hello,


Can anyone help, please?

I have a table with manager names running down column A, and dates running along row 1. Inside the table formulas have brough back whether the member of staff is working a day or night shift.

I need to 'turn the table around', so that the table now reads:
Dates running down column A, DAY SHIFT in column B and NIGHT SHIFT in column C, with column C bringing back the manager name from the table mentioned above. This needs to be formulated as the dates are reading of a larger table with a user defined start date, for instance giving someone the ability to look at a fortnight to see who is the covering manager for the day and night shift.