Transpose table format with dates from horizontal to vertical

Hello,

I have table with a lot of data, it is an attendance list table with the below horizontal format, it lists the attendance taken from(Date Start) > to (Date End)
the problem is that it has Mon to Sun without dates.

I need to list each row for each week day with the corresponding date and the presence letter, like "A" for absent and "P" for present.
So instead I need to delete all weekdays columns and transpose to rows with the matching date of the weekday.

It is not easy to explain this, but if you have a look at the attached excel you will get it.
It is a big challenge and couldn't find a way.

From this format:

ID Program Date From Date To Mon Tue Wed Thu Fri Sat Sun
555333 BA 9/20/2021 9/22/2021 P P P - - - -
555444 BAA 9/20/2021 9/26/2021 P P P A P A P


To this format:


ID Program Date Presence
555333 BA 9/20/2021 P
555333 BA 9/21/2021 P
555333 BA 9/22/2021 P
555444 BAA 9/20/2021 P
555444 BAA 9/21/2021 P
555444 BAA 9/22/2021 P
555444 BAA 9/23/2021 A
555444 BAA 9/24/2021 P
555444 BAA 9/25/2021 A
555444 BAA 9/26/2021 P

Any Idea?

Thanks

Ohh that's marvelous! thanks a lot Glenn, I wouldn't have found a way myself.