need some help to transform my table

[Krijgersss]

Hello  i need some help wit transforming i thank it something with pivot table.

i have this table ( see screenshot) 

colum 2 is my key and the colom with the number values i need. now all these colums are months iwant all this colums in colum with the date of the month like this 

it needs to be like the tabel i made below so colum 1 and 2 will stay the same and all the other colums wil have a date  with the value next to it so it has to be something wit pivot is what i think

colum1	colum 2 (key)	Date	values
omzet digitale	80400	01-01-2024	value of colum jan
omzet	80450	01-02-2024	Values of feb

[bhanu_gautam · Accepted solution]

@Krijgersss , You can do that using unpivot 

In the Power Query Editor, select the columns that you want to keep as they are (e.g., colum1 and colum2).
Right-click on the selected columns and choose Unpivot Other Columns. This will transform the monthly columns into rows.

Add a custom column to convert the month names to dates. You can use a formula like this:

#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Date", each Date.FromText("01-" & [Attribute] & "-2024"), type date)