Forum Discussion
Solved
reorder columns dynamically
I have the following table: Brand Version 01/2023 02/2023 04/2023 06/2023 07/2023 AA 1CV 500 800 890 4560 8045 AB 5CV null null 750 4890 9650 AC 1CV 300 null 8...
= Table.AddColumn(#"changetype", "Column4", each "Price")
= Table.ReorderColumns(#"Added Custom",List.InsertRange(Table.ColumnNames(#"changetype"),2,{"Column4"}),MissingField.Ignore)
= Table.AddColumn(#"changetype", "Column4", each "Price")
= Table.ReorderColumns(#"Added Custom",List.InsertRange(Table.ColumnNames(#"changetype"),2,{"Column4"}),MissingField.Ignore)