Copy field down throughout column to fix formatting

[dwedding3]

So I basically want to change a file from this:

To this

In power query. How do I do that dynamically?

[jgeddes · Accepted solution]

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.