Convert excel unstructured data to defined table

excel
activities
studio

#1

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


#2

Can you try the below logic ?

image