Power Query: Combine records with deliminter

This should do it:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(
        Source, 
        List.RemoveItems(Table.ColumnNames(Source),{"Color","Year"}), 
        {
            {"Color", each Text.Combine(Table.Column(_,"Color"),";"), type text}, 
            {"Year", each Text.Combine(List.Transform(Table.Column(_,"Year"), each Text.From(_)),";"), type text}
        }
    ),
    #"Reordered Columns" = Table.ReorderColumns(#"Grouped Rows",Table.ColumnNames(Source))
in
    #"Reordered Columns"