1 2 3 4 5 6 7 8 9 10
| let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
#"Regroupement+Index" = Table.Group(Source, {"RUPT CDE", "CLI"}, {{"Données", each Table.AddIndexColumn(_,"Index",1)}}),
Developpement = Table.ExpandTableColumn(#"Regroupement+Index", "Données", {"Qte Cde", "ARTICLE", "Index"}, {"Qte Cde", "ARTICLE", "Index"}),
Dépivot = Table.UnpivotOtherColumns(Developpement, {"RUPT CDE", "CLI", "Index"}, "Attribut", "Valeur"),
Tri = Table.Sort(Dépivot,{{"Index", Order.Ascending},{"Attribut", Order.Ascending}}),
Fusion_Colonne = Table.CombineColumns(Table.TransformColumnTypes(Tri, {{"Index", type text}}, "fr"),{"Attribut", "Index"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Attribut.1"),
Pivot = Table.Pivot(Fusion_Colonne, List.Distinct(Fusion_Colonne[Attribut.1]), "Attribut.1", "Valeur")
in
Pivot |
Partager