Re,
Un exemple Power Query.
Cdlt.
let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
GroupedRows = Table.Group(Source, {"Type"}, {{"GroupedRows", each _, type table [Type=text, Valeur=number]}}),
AddedIndex = Table.AddColumn(GroupedRows, "Personnalisé", each Table.AddIndexColumn([GroupedRows],"Index",1,1,Int64.Type)),
ExpandedData = Table.ExpandTableColumn(AddedIndex, "Personnalisé", {"Valeur", "Index"}, {"Valeur", "Index"}),
SortedRows = Table.Sort(ExpandedData,{{"Type", Order.Ascending}}),
RemovedColumns1 = Table.RemoveColumns(SortedRows,{"GroupedRows"}),
PivotedColumn = Table.Pivot(RemovedColumns1, List.Distinct(RemovedColumns1[Type]), "Type", "Valeur"),
RemovedColumns2 = Table.RemoveColumns(PivotedColumn,{"Index"})
in
RemovedColumns2