Convert excel unstructured data to defined table

Hi Friends,

Could someone tell me how to convert the below data

like below.

image

Days order can be anything.

Any help would be greatly appreciated !

Thanks,
Devi

Can you try the below logic ?

image