Forum Discussion

clubspec's avatar
clubspec
Helper 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" fuction later to fill the blank.

Is there a way to do it?

 

Thanks,
Raymond

Need Help

3 Replies

  • Payeras_BI's avatar
    Payeras_BI
    Solution Sage
    5 years ago

    Hi clubspec ,

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

    To here:

     

     

    • clubspec's avatar
      clubspec
      Helper III
      5 years ago

      Thank you Mallorca, you are legend!

      I made it work by going into Advanced Editor and use Table.Skip.  However, do you know if there is button made for this Table.Skip fuction?

  • Payeras_BI's avatar
    Payeras_BI
    Solution 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.