Merging queries with partial common column

Ocasio27 

If you mean transform left part of the screenshot to right one as

you may query the range, replace empty values on null (I had space when copy/pasted, replace what you actually have), group by first column adding aggregation for each next column with All rows; in formula bar replace group aggregation by removing nulls and returning first value. Entire script 

let
    Source = Excel.CurrentWorkbook(){[Name="Range"]}[Content],
    #"Replaced Value" = Table.ReplaceValue(
      Source," ",null,
      Replacer.ReplaceValue,{"Column2", "Column3", "Column4", "Column5"}
    ),
    #"Grouped Rows" = Table.Group(
      #"Replaced Value",
      {"Column1"},
      {
        {"Column2", each List.First(_[Column2])},
        {"Column3", each List.First( List.RemoveNulls( _[Column3]))},
        {"Column4", each List.First( List.RemoveNulls( _[Column4]))},
        {"Column5", each List.First( List.RemoveNulls( _[Column5]))}
      }
    )
in
    #"Grouped Rows"