let
Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Категория товара", type text}, {"Вид товара", type text}, {"01.01.2019", Int64.Type}, {"01.02.2019", Int64.Type}, {"01.03.2019", Int64.Type}, {"01.04.2019", Int64.Type}, {"01.05.2019", Int64.Type}, {"01.06.2019", Int64.Type}, {"01.07.2019", Int64.Type}, {"01.08.2019", Int64.Type}, {"01.09.2019", Int64.Type}, {"01.10.2019", Int64.Type}, {"01.11.2019", Int64.Type}, {"01.12.2019", Int64.Type}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Вид товара"}),
#"Grouped Rows" = Table.Group(#"Removed Columns", {"Категория товара"}, {{"Янв", each List.Sum([01.01.2019]), type nullable number}, {"Фев", each List.Sum([01.02.2019]), type nullable number}, {"Мар", each List.Sum([01.03.2019]), type nullable number}, {"Апр", each List.Sum([01.04.2019]), type nullable number}, {"Май", each List.Sum([01.05.2019]), type nullable number}, {"Июн", each List.Sum([01.06.2019]), type nullable number}, {"Июл", each List.Sum([01.07.2019]), type nullable number}, {"Авг", each List.Sum([01.08.2019]), type nullable number}, {"Сен", each List.Sum([01.09.2019]), type nullable number}, {"Окт", each List.Sum([01.10.2019]), type nullable number}, {"Ноя", each List.Sum([01.11.2019]), type nullable number}, {"Дек", each List.Sum([01.12.2019]), type nullable number}}),
#"Demoted Headers" = Table.DemoteHeaders(#"Grouped Rows"),
#"Changed Type1" = Table.TransformColumnTypes(#"Demoted Headers",{{"Column1", type text}, {"Column2", type any}, {"Column3", type any}, {"Column4", type any}, {"Column5", type any}, {"Column6", type any}, {"Column7", type any}, {"Column8", type any}, {"Column9", type any}, {"Column10", type any}, {"Column11", type any}, {"Column12", type any}, {"Column13", type any}}),
#"Transposed Table" = Table.Transpose(#"Changed Type1"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
#"Changed Type2" = Table.TransformColumnTypes(#"Promoted Headers",{{"Категория товара", type text}, {"Категория1", Int64.Type}, {"Категория2", Int64.Type}, {"Категория3", Int64.Type}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type2",{{"Категория товара", "Месяц"}}),
#"Unpivoted Only Selected Columns" = Table.Unpivot(#"Renamed Columns", {"Категория1", "Категория2", "Категория3"}, "Attribute", "Value")
in
#"Unpivoted Only Selected Columns"
|