How to change "dates" to clean data

[danhendo888]

https://1drv.ms/x/s!AvjBsEPEq12ngUI4aV0PG-l-4gVM?e=pByejI

How do I convert the data in A1:B7 to the output in rows 12 and below (happy to use any method, pivot tables, power query etc)

(Purpose is so that I can do YTD calculations using the output)

 

[privxls]

Not sure if this would resolve it but here's what I have in mind:

Just merge the 'Year' which means A1:A7 would be merged (as they are of the same year) then insert a column between A and B and type in 'Months' and then perform a chart for B7:C7 then just rename the chart name.

If this does not answer your question, I hope this gets answered by the experts