// Таблица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"