let
    from = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    prof = Table.Buffer(Table.Profile(from)),
    lstrem = Table.SelectRows(prof, (x)=> x[Count]=x[NullCount])[Column],
    rem = Table.RemoveColumns(from, lstrem),
    f = (x)=> [a = Table.RemoveColumns(x, {"Группа", "АВС 4 кв 2025"}),
              f = (x)=> 
                 [tbl = Table.RemoveColumns(x, "Индекс Х-Х 4 кв. 2025"),
                  pvt = Table.Pivot(tbl, {"X", "Y", "Z"}, "XYZ 4 кв. 2025", "Номенклатура", (x)=> x ),
                  nms = List.Buffer(Table.ColumnNames(pvt)), 
                  tolst = Table.ToList(pvt, (x)=> List.Zip(x)),
                  cmb = List.Combine(tolst),
                  frlst = Table.FromList(cmb, (x)=>x, nms) ][frlst],             
              gr = Table.Group(a, "Индекс Х-Х 4 кв. 2025", {"tmp", f}),
              exp = Table.ExpandTableColumn(gr, "tmp", List.Distinct(List.Combine(List.Transform(gr[tmp], Table.ColumnNames))))][exp],
    gr = Table.Group(rem, {"Группа", "АВС 4 кв 2025"}, {"tmp", f} ),
    exp = Table.ExpandTableColumn(gr, "tmp", List.Distinct(List.Combine(List.Transform(gr[tmp], Table.ColumnNames))))
in
    exp

let
    from = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    f = (x)=>  
        [a = ((tbl)=> Table.Group(tbl, "НомерПалл", {{"Количество", Table.RowCount}} ))(x[[НомерПалл]]),
         b = Table.RowCount(Table.SelectRows(a, (y)=> y[Количество] = 1)),
         c = Table.RowCount(Table.SelectRows(a, (y)=> y[Количество] > 1))], 
    gr = Table.Group(from, "Приемщик",  {{"Уник", (x)=> f(x)[b]}, {"Неуник", (x)=> f(x)[c]}} )
in
    gr

let
    gen = List.Generate(
            ()=> [num = 1, Name = "Иван", Surname = "Иванов"],
            (x)=> x[num] <=10,
            (x)=> [num = x[num] + 1, Name = "Иван", Surname = "Иванов"])
in
    gen

=ЕСЛИ(ПОИСКПОЗ(B2;$A$6:$M$6;0)>0;"Есть";"Нет")