Transposing data Excel

My excel looks like this
And I want to create a file like this

Thank you for providing additional information.

Are you expecting us to enter the data manually into excel so we can create an example for you?

Please attach or email the actual files

These are the files you need to use.

Thank you.

Can I ask you to highlight the data you want to go into the output file
And attach it here
(Similar to the one below)

Hi,

Maybe I am not explaining it correctly.
I am trying to understand what you are trying to achieve.
The files you provided do not help me.
I understand where the year and month are coming from but I do not understand the rest