let
    Source = Excel.CurrentWorkbook(){[Name="Sheet1"]}[Content],
    #"Removed Other Columns1" = Table.SelectColumns(Source,{"НоменклатураНаименование5", "Сумма продаж год-1"}),
    #"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns1",null,0,Replacer.ReplaceValue,{"Сумма продаж год-1"}),
    #"Added Index" = Table.AddIndexColumn(#"Replaced Value", "Индекс", 0, 1, Int64.Type),
    #"Grouped Rows" = Table.Group(#"Added Index", {"НоменклатураНаименование5"}, {{"a", each 
    let a= Table.Sort(_,{{"Сумма продаж год-1",1}}),l = a[#"Сумма продаж год-1"],sum =  List.Sum(l),n = List.Count(l), 
    g = 
    List.Generate( 
        ()=>[i=0, s=l{0}, t = if s<(sum*0.5) then "A" else if s>(sum/2) then "A" else if s<(sum*0.5) then "A" else if s<(sum*0.8) then "B" else if s<(sum*0.95) then "C" else "D"],
        each [i]<n, 
        each [i=[i]+1,  s= [s] + l{i}, t = if s<(sum*0.5) then "A" else if s<(sum*0.8) then "B" else if s<(sum*0.95) then "C" else "D"],
        each [t]) in Table.FromColumns(Table.ToColumns(a)&{g},Table.ColumnNames(a)&{"Группа"})}}),
    Custom1 = Table.Combine(#"Grouped Rows"[a]),
    #"Sorted Rows" = Table.Sort(Custom1,{{"Индекс", Order.Ascending}}),
    #"Removed Columns" = Table.RemoveColumns(#"Sorted Rows",{"Индекс"})
in
    #"Removed Columns"

let
    Источник = Excel.CurrentWorkbook(){[Name="Таблица3"]}[Content],
    #"Измененный тип" = Table.TransformColumnTypes(Источник,{{"PC_Name", type text}, {"Mon_vendor", type text}, {"Mon_SN", type text}}),
    #"Сгруппированные строки" = Table.Group(#"Измененный тип", {"PC_Name"}, { {"Mon_vendor", each Text.Combine([Mon_vendor],"/"), type nullable text}, {"Mon_SN", each Text.Combine([Mon_SN],"/") }})
in
    #"Сгруппированные строки"

let
    Source = Folder.Files("C:\Users\user\Desktop\Новая папка (5)"),
    #"Added Custom" = Table.AddColumn(Source, "a", each let
    Source = Excel.Workbook([Content], null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"a", Int64.Type}, {"b", Int64.Type}, {"c", Int64.Type}})
in
    let  a = _[Name] in Table.AddColumn( #"Changed Type","Источник",  (_)=> a)
),
    Custom1 = Table.Combine( #"Added Custom"[a])
in
    Custom1