Remove Last Row Based Upon New Data of Different Column|Power Query|Excel Forum|My Online Training Hub

Wondering the best way to go about this.

I have a query that to begin, has one row like this.  This is the row to show when there is no other data:

Column1                Column2

Not Started             null

This is how it should look with no other data.  

As data comes in, it looks like this:

Column1                Column2

Test                        Yes

Not Started              null

What I would like for it to look like is this:

Column1                Column2

Test                       Yes

Basically, to start, I want the "Not Started" row to remain.  However, as soon as Column2 populates with data, I would like the "Not Started" row to be removed.  Filtering is not accomplishing what I would like.    

I was looking to basically remove the last row based upon Colum2 not being null.  But if it is null, I need to keep that last row.