1 2 3 4 5 6
| let
Source = Excel.CurrentWorkbook(){[Name="TableauHorizontal"]}[Content],
#"Type modifié" = Table.TransformColumnTypes(Source,{{"CODE CLIENT", type text}, {"ID", Int64.Type}, {"DIV", type text}, {"REP.", Int64.Type}, {"S/A", type text}, {"C", type text}, {"CLIENT", type text}, {"REF 1", Int64.Type}, {"REF 2", Int64.Type}, {"REF 3", Int64.Type}, {"REF 4", Int64.Type}, {"REF 5", Int64.Type}, {"REF 6", Int64.Type}, {"REF 7", Int64.Type}, {"REF 8", Int64.Type}, {"REF 9", Int64.Type}}),
#"Tableau croisé dynamique des colonnes supprimé" = Table.UnpivotOtherColumns(#"Type modifié", {"CODE CLIENT", "ID", "DIV", "REP.", "S/A", "C", "CLIENT"}, "Attribut", "Valeur")
in
#"Tableau croisé dynamique des colonnes supprimé" |
Partager