I want to transpose shift doctor calendar to Array

Hello, I have a doctor shift table like first picture and I want to transpose to Array by have A column is Date and B column is Doctor name and have others like an example table.

Could anyone help me please?

Doctor shift calendar.

Example transpose table