Forum Discussion
Solved
Copy field down throughout column to fix formatting
So I basically want to change a file from this:
To this
In power query. How do I do that dynamically?
You can use Table.FillDown() to achieve the result.
As Table.FillDown replaces null values you will have to replace the blank values in Column1 with null values prior to using Table.FillDown.
A sample code for that would be...= Table.FillDown(Table.ReplaceValue(yourPreviousStep, "", null, Replacer.ReplaceValue, {"Column1"}), {"Column1"})Hope this helps.
1 Reply
You can use Table.FillDown() to achieve the result.
As Table.FillDown replaces null values you will have to replace the blank values in Column1 with null values prior to using Table.FillDown.
A sample code for that would be...= Table.FillDown(Table.ReplaceValue(yourPreviousStep, "", null, Replacer.ReplaceValue, {"Column1"}), {"Column1"})Hope this helps.