PowerQuery - About Using the First Two Lines as Headers

Here's one way to do it in the query editor.  To see how it works, just create a blank query, open the Advanced Editor and replace the text there with the M code below.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUtIBIQ9jEGGiFKsTreRhCGIbQSTAIolABkgQQoNEkoAskAoIDRJJBrJAhkDo2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t, Column4 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}}),
    Custom1 = #"Changed Type",
    Custom2 = Table.FromColumns(List.Transform(Table.ToColumns(Custom1), each if List.Contains({null, ""}, _{0}) then List.RemoveFirstN(_, 1) else List.RemoveRange(_,1,1) )),
    #"Promoted Headers" = Table.PromoteHeaders(Custom2, [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"H1", type text}, {"H2", Int64.Type}, {"H3", type text}, {"H4", Int64.Type}})
in
    #"Changed Type1"

Pat