Forum Discussion
Solved
Unpivot table
Hello, I have a table which shows the financial info as below: year Actuals January Actuals Feburary .... Actuals December Forecast January ... Decemeber Budget January ... December ...
NewStep=Table.Pivot(Table.SplitColumn(Table.UnpivotOtherColumns(YourTableName,{"year"},"x","Value"),"x",each Text.Split(_," "),{"x","Month"}),{"Actual","Forecast","Budget"},"x","Value")
NewStep=Table.Pivot(Table.SplitColumn(Table.UnpivotOtherColumns(YourTableName,{"year"},"x","Value"),"x",each Text.Split(_," "),{"x","Month"}),{"Actual","Forecast","Budget"},"x","Value")
Thanks, it works!