Forum Discussion

clubspec's avatar
clubspec
Icon for Helper III rankHelper III
5 years ago
Solved

Remove only few first blank rows using power query

Hi Gurus, I have data ordered by the latest to older.  I have a column where I only want to remove the first few blank rows.  Not all the rows that are blank because I want to perform a "fill down" ...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi clubspec ,

    If I understood correctly your requirement you want to go from here:

    To here:

     

     

Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi clubspec ,
I usually use this option specifying any number of top rows to be removed and then edit the function on the Formula Bar.