Forum Discussion
need some help to transform my table
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 |
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)
1 Reply
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)