There are times that you you want to use the Table.Skip Power Query function, but the number of rows you want to skip varies from file to file in your folder. You want the number of rows to be dynamic.

The function below will count the number of rows under the column Column4 while the rows are nulls.

Table.Skip(Source, each [Column4] = null)

Watch the video.