Bonjour à tous !
Et....
Une proposition de requête ?
let
Source = Excel.CurrentWorkbook(){[Name="Tableau8"]}[Content],
GroupBy = Table.Group(Source, {"Reference"}, {{"tbl", each Table.FirstN(Table.Sort(_,{"NumeroVisa",1}),1)},{"Occurence", each Table.RowCount(_), Int64.Type}}),
Expand = Table.ExpandTableColumn(GroupBy, "tbl", {"Visa", "NumeroVisa"})
in
Expand