Converting weekly to monthly data and Yearly data to monthly

Hello guys, I hope someone can help me.
I have panel weekly data that I want to convert to monthly frequency, and also annual data that I need in monthly frequency.

Can anyone help me out with this?

Many thanks
Milica

Hello,

thank you for your quick response to my question.

I attached the workfile - as you can see I have weekly panel data that I need to convert to monthly data.

Kind regards,
Milica

For example, you create PT, and groups in this example row labels of the years and months

Hello,

thank you for your response.

Unfortuantely, I have a panel data as attached and I dont know how to take care of different variables at different times observations when creating pivot table

https://youtu.be/iGuaCpuB3lU
See a short video instructions, which I recorded to aid

Thank you so so so much