// Таблица1 (3)
let
Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Артикул", "Номенклатура.Вид номенклатуры", "Номенклатура.Группа", "Номенклатура.Поставщик", "Уник", "Номенклатура.Параметр"}, "Атрибут", "Значение"),
#"Extracted Text Before Delimiter" = Table.TransformColumns(#"Unpivoted Other Columns", {{"Атрибут", each Text.BeforeDelimiter(_, " "), type text}}),
#"Added Index" = Table.AddIndexColumn(#"Extracted Text Before Delimiter", "Индекс", 0, 1),
#"Integer-Divided Column" = Table.TransformColumns(#"Added Index", {{"Индекс", each Number.IntegerDivide(_, 3), Int64.Type}}),
#"Pivoted Column" = Table.Pivot(#"Integer-Divided Column", List.Distinct(#"Integer-Divided Column"[Атрибут]), "Атрибут", "Значение"),
Group = Table.Group(#"Pivoted Column", {"Артикул", "Номенклатура.Вид номенклатуры", "Номенклатура.Группа", "Номенклатура.Поставщик"}, {{"Номенклатура.Параметр", each _[#"Номенклатура.Параметр"]{0}}, {"Уник", each _[Уник]{0}}, {"Индекс", each _[Индекс]{0} }, {"a", (sub)=> let
#"Grouped Rows" = Table.Group(sub, {"размер"}, {{"кол", each List.Sum([#"кол-во"]), type number}, {"цена", each List.Max([цена]), type number}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Grouped Rows", {}, "Атрибут", "Значение"),
#"Transposed Table" = Table.Transpose(#"Unpivoted Columns"){1} in
#"Transposed Table", type record}}),
#"Sorted Rows" = Table.Sort(Group,{{"Индекс", Order.Ascending}}),
#"Added Custom" = List.Transform({1..List.Max(Table.AddColumn(#"Sorted Rows", "b", each List.Count(Record.FieldNames([a])))[b])}, each "Column"& Text.From(_)),
#"Expanded {0}" = Table.ExpandRecordColumn(#"Sorted Rows", "a", #"Added Custom"),
#"Removed Columns" = Table.RemoveColumns(#"Expanded {0}",{"Индекс"})
in
#"Removed Columns"
|