CSV import: Remove TOP junk rows during

[Anonymous]

@ChandeepChhabra has created an amazing video that demonstrates this approach.

Here is a bit adjusted code wrapped in a function (copy/paste ready solution, no need to watch video every time):

= (Source as table, _lColumnNames as list) =>
let
    TrueIfContainsColumnnames = Table.AddColumn(Source, "__CustomTemp__", each List.ContainsAll(Record.ToList(_),_lColumnNames)),
    SkipTill1stTrue = Table.Skip(TrueIfContainsColumnnames,each [__CustomTemp__]<>true),
    RemoveTempColumn = Table.RemoveColumns(SkipTill1stTrue,{"__CustomTemp__"}),
    Result = RemoveTempColumn
in
    Result

Example:

Problem: 

Solution (2nd parameter is a list of column names that uniquely identifies the header row): 

Download