transpose row to columns

[gio1082]

Hi,

a have a lot of data in the following data form. 

I want to transform it like this 

How do I do it in the power query? thank you in advance

[amitchandak · Accepted solution]

@gio1082 , first is select ID and unpivot other columns

https://radacad.com/pivot-and-unpivot-with-power-bi

rename column , create month column

create a new column  Date

= Date.FromText("01-"&[Month]&"-2022")

[gio1082]

Thank you!