Forum Discussion
Auto replace all values in all columns with specific value
Hello, I have the following table loaded in Power Query which is updated regularly with changing number of columns in the source Excel spreadsheet. I am trying to find a dynamic way to replace all v...
You can replace
{"Week number", "Stock", "Sold", "Returns"}with
Table.ColumnNames(Source)
You can replace
{"Week number", "Stock", "Sold", "Returns"}with
Table.ColumnNames(Source)