convert data automatically?

[Bangenge]

I'm not good at all on VBA.

Attached is the excel file which I compressed.

Can anyone help me please to turn the data on sheet1 into the data on sheet2?

The data on the sheet1 always varies everyday so there's no exact data will remain on the same column or row on the following day.

I've been doing this manually by copying and pasting it.
And it takes me around 1 hour if its the end of the month.

Any help using macro/vba will be greatly appreciated.

Thanks!