let Source = #"0 Utilisation des ressources brute", #"Removed Columns" = Table.RemoveColumns(Source,{"Coût"}), #"Transposed Table" = Table.Transpose(#"Removed Columns"), #"Filled Down" = Table.FillDown(#"Transposed Table",{"Column1"}), #"Promoted Headers" = Table.PromoteHeaders(#"Filled Down", [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Column1", Int64.Type}, {"Ressources", type text}, {"Non affecté", Int64.Type}, {"@Analyste1", Int64.Type}, {"@Ingénieur Fab1", Int64.Type}, {"@EXPERT METIER1", Int64.Type}, {"@MANAGER DE PROJET", type number}, {"@.H Budget Charge Interne 2019", Int64.Type}, {"@Développeur1", Int64.Type}, {"€B Budget Achats Mat 2019", Int64.Type}, {"€ Matériel", Int64.Type}, {"€ Prestations", Int64.Type}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Année"}, {"Ressources", "Mois"}}), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Renamed Columns", {"Année", "Mois"}, "Attribut", "Valeur"), #"Changed Type1" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Année", type text}}), #"Renamed Columns1" = Table.RenameColumns(#"Changed Type1",{{"Attribut", "Ressources"}, {"Valeur", "Coût"}}), #"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"Mois", "Année", "Ressources", "Coût"}), #"Merged Columns" = Table.CombineColumns(#"Reordered Columns",{"Mois", "Année"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"DateMois"), #"Changed Type2" = Table.TransformColumnTypes(#"Merged Columns",{{"DateMois", type date}}) in #"Changed Type2"