Creating a header from the first two rows

jerryr125 
Create a blank Query, go to the Advanced Editor, clear the existing code, and paste the codes give below and follow the steps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("JYu5DcBADMN2UX2FnT+zGC7yZ/8JIjkFCUKAIrChYScHOZEtcLFu8pC3FjdmJ/XSYLWO6kmapeVfV7VbuX7OY+YH", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t, Column4 = _t]),
    Custom1 = Table.FromRows({List.Transform(Table.ToColumns(Table.FirstN(Source,2)) , each Text.Combine(_) )}),
    Custom2 = Table.PromoteHeaders(Table.Combine( {Custom1 , Table.Skip(Source,2)} ))
in
    Custom2

Hi jerryr125 

= Table.FromRows(
      List.Skip(Table.ToRows(Source), 2),
      List.Transform(
         List.Zip({Record.ToList(Source{0}), Record.ToList(Source{1})}),
         Text.Combine))

Stéphane

Hi jerryr125 , Could you please try this 

• Promote the first row to headers: Use the "Use First Row as Headers" option.
• Combine the first two rows:
  1. Select both rows.
  2. Use the "Transform" tab > "Merge Columns."
  3. Select desired delimiter.
     If this post helped please do give a kudos and accept this as a solution
     Thanks In Advance

Hi jerryr125, another solution:

Add this code as a new step, replace Source in code with your previous_step_name if necessary.

= Table.PromoteHeaders(Table.FromColumns(List.TransformMany(Table.ToColumns(Source),
        each {List.Skip(_, 2)},
        (x,y)=> {Text.Combine(List.FirstN(x, 2))} & y)))