Forum Discussion

dwedding3's avatar
dwedding3
Frequent Visitor
1 year ago
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?  
Need Help
  • jgeddes's avatar
    jgeddes
    1 year ago

    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. 

jgeddes's avatar
jgeddes
Super User
1 year ago

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.