let
Source = Excel.CurrentWorkbook(){[Name="BasisData"]}[Content],
cTypes = Table.TransformColumnTypes(Source,{{"OPDRACHT-RITID", type text}, {"OPDRACHT", Int64.Type}, {"VOLG", Int64.Type}, {"ACTIVITEITID", Int64.Type}, {"OP_S", Int64.Type}, {"ZEND_STATUS", type text}, {"DEB_CODE", Int64.Type}, {"DEB_NAAM", type text}, {"REFERENTIE", Int64.Type}, {"LAADDATUM", type datetime}, {"LAADNAAM", type text}, {"LA_PC", Int64.Type}, {"LAADPLAATS", type text}, {"LA_LAND", type text}, {"LAADADRESKEY", type text}, {"LOSDATUM", type datetime}, {"LOSNAAM", type text}, {"LO_PC", Int64.Type}, {"LOSPLAATS", type text}, {"LO_LAND", type text}, {"LOSADRESKEY", type text}, {"LDM", type number}, {"COL", Int64.Type}, {"PP", Int64.Type}, {"WHS_NR", type any}, {"WT_TOT", Int64.Type}, {"LO_AANK", type datetime}, {"LO_VERTR", type datetime}, {"LA_VAN", type any}, {"LA_TOT", type any}, {"LO_VAN", type number}, {"LO_TOT", type number}, {"LA_AANK", type any}, {"LA_VERTR", type any}, {"EURO", Int64.Type}, {"ROLC", Int64.Type}, {"LA_PAL_B", type any}, {"LO_PAL_B", Int64.Type}, {"RITID", Int64.Type}, {"RITSTATUS", type text}, {"WAGEN", type text}, {"TYPE", type text}, {"TRAILER", Int64.Type}, {"WERK_BEGIN", type datetime}, {"WERK_EINDE", type datetime}, {"STAND", type text}, {"REGEL", Int64.Type}, {"RIT_TYPE", type text}, {"E_GELE", Int64.Type}, {"E_GELA", Int64.Type}, {"RC_GELE", Int64.Type}, {"RC_GELA", Int64.Type}, {"MOB_VOLG", Int64.Type}, {"MOB_C", type text}, {"A_R_G_P", type text}, {"AFH_CON", type text}, {"BEGIN", type datetime}, {"CHAUFFEUR", type text}}),
cols = List.RemoveItems(Table.ColumnNames(cTypes), {"MOB_C", "MOB_VOLG"}),
grp = Table.Group(cTypes, cols, {{"MOB_C", each Text.Combine(_[MOB_C]," - ")}, {"MOB_VOLG", each List.Max(_[MOB_VOLG])}})
in
grp