Power Query Spliting table with multiple columns into rows based on col1

Pawel_Sz 

As variant

let
    Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
    names = { "Dependency" ,"Dependency Date"},
    combineDependency = Table.SelectColumns( Table.AddColumn(
        Source,
        "Data",
        each #table( names,
            List.Zip( {
                List.RemoveNulls( List.Alternate( Record.FieldValues(_), 1, 1 ) ),
                List.RemoveNulls( List.Alternate( List.Skip( Record.FieldValues(_) ), 1, 1 ) )
                } )
        ), type table [Dependency = text, #"Dependency Date" = date] ),
        {"Project", "Data"} ),
    expandDependency = Table.ExpandTableColumn(
        combineDependency,
        "Data", names, names ),
    declareType = Table.TransformColumnTypes(
        expandDependency,
        {
            {"Project", type text},
            {"Dependency Date", type date}
        })
in
    declareType