Formatting table using VBA- Need help!

Hi, I've been trying to get this done to analyze the data. However, I am unable to un-pivot this table. Could someone please guide me here?

Input table-


A A A A A B B B B B
WEEK MON TUE WED THURS FRI MON TUE WED THURS FRI
1 100 100 100 100 100 100 100 100 100 100
2 150 150 150 150 150 150 150 150 150 150


Desired Output-

Biz Week Day Total
A 1 MON 100
A 1 TUE 100
A 1 WED 100
A 1 THURS 100
A 1 FRI 100
A 2 MON 150
A 2 TUE 150
A 2 WED 150
A 2 THURS 150
A 2 FRI 150
B 1 MON 100
B 1 TUE 100
B 1 WED 100
B 1 THURS 100
B 1 FRI 100
B 2 MON 150
B 2 TUE 150
B 2 WED 150
B 2 THURS 150
B 2 FRI 150

Thanks in advance!