Power Query: Filter columns by condition

[Mer333]

Hi all!

Does anyone know is there any way to filter columns by condition like... at least one of the first 4 rows in a column is not blank (null)?

I'm searching an Internet for this case for almost two days but without any success yet.

 

[miguel.escobar]

Sometimes, the easiest solution can surprise us

let
Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
#"Filled Up" = Table.FillUp(Source,{"Column2"}),
#"Filtered Rows" = Table.SelectRows(#"Filled Up", each ([Column1] <> null))
in
#"Filtered Rows"

the filled up will work if we have the 2nd patter that you sent me. The last one that you provided is not clear to me yet.