let
    Источник = Folder.Files("E:\456\Test"),
    #"Другие удаленные столбцы" = Table.SelectColumns(Источник,{"Content", "Name"}),
    #"Извлеченный текст между разделителями" = Table.TransformColumns(#"Другие удаленные столбцы", {{"Name", each Text.BetweenDelimiters(_, "_v1_", ".xlsx"), type text}}),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Извлеченный текст между разделителями", {{"Name", type date}}, "ar-DZ")
in
    #"Changed Type with Locale"

let
    Источник = Binary.Buffer(File.Contents("C:\Обработки\Источник_логистика\ИсходныеЛогистика.xlsx")),
    СодержимоеКниги = Excel.Workbook( Источник, null, false )
in
    СодержимоеКниги

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "Т", each Splitter.SplitTextByAnyDelimiter({";",","})([Заказ])),
    #"Expanded {0}" = Table.ExpandListColumn(#"Added Custom", "Т"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Expanded {0}", "Т", Splitter.SplitTextByEachDelimiter({"-"}, QuoteStyle.Csv, false), {"Т.1", "Т.2"}),
    #"Replaced Value" = Table.ReplaceValue(#"Split Column by Delimiter","шт","",(a,b,c)=> List.Max({1, Number.From(Text.Replace(a,b,c))}),{"Т.2"}),
    #"Grouped Rows" = Table.Group(#"Replaced Value", {"№", "Менеджер", "Заказ"}, {{"Количество товаров", each List.Sum([Т.2]), type number}})
in
    #"Grouped Rows"

let
    fx = (t)=> Text.Combine( Splitter.SplitTextByRepeatedLengths(10)(Text.Select(t,{"0".."9","."})),"; "),
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    Out = Table.TransformColumns(Source,{{"Поле 2", fx, type text}, {"Поле 3", fx, type text}})
in
    Out

=ЕСЛИ(B6<МИН(B1;B3)*15%;"да";"нет")

let
    Source = Excel.CurrentWorkbook(){[Name="ИменованныйДиапазон"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "УровеньИерархии", each Text.Length( Text.Select([Column1],".") ), Int64.Type ),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Товар", each if [УровеньИерархии] = 1 then [Column1] else null),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Вид товара", each if [УровеньИерархии] = 2 then [Column1] else null),
    #"Added Custom3" = Table.AddColumn(#"Added Custom2", "Тип товара", each if [УровеньИерархии] = 3 then [Column1] else null),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom3",{"Column1", "УровеньИерархии"}),
    #"Filled Down" = Table.FillDown(#"Removed Columns",{"Товар", "Вид товара"}),
    #"Filtered Rows" = Table.SelectRows(#"Filled Down", each ([Тип товара] <> null)),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Товар", "Вид товара"}, {{"tab", each [Тип товара]}}),
    #"Added Custom4" = Table.AddColumn(#"Grouped Rows", "tab1", each Table.FromColumns({{[Товар]},{[Вид товара]},[tab]},Table.ColumnNames(#"Filtered Rows"))),
    tab1 = Table.Combine(#"Added Custom4"[tab1]),
    #"Added Custom5" = Table.AddColumn(tab1, "Описание товара", each null)
in
    #"Added Custom5"

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    AddedCustom = Table.AddColumn(
        Source, 
        "IP коммутатора", 
        each Text.Combine( 
            List.Transform(
                Text.Split([Адреса],"];"), 
                each Text.Remove( 
                    if Text.Contains(_,"[") then Text.AfterDelimiter(_, "[", {0, RelativePosition.FromEnd}) else null, 
                    "]") ), 
            "#(lf)" ) )
in
    AddedCustom

let
    Источник = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    Вывод = Table.TransformColumns(
        Источник, 
        List.Transform( 
            Table.ColumnNames(Источник), 
            each {_,(t)=>Text.Split(Text.From(t),"; "), type list}) )
in
    Вывод

= Table.TransformColumnTypes(
            ФильтрацияПолей,
            List.Transform(СпискоПолей, each {_,type text})
            )

Table.ReplaceValue(тип, each [УПС], 0,(a,b,c)=> if b = 250 and a = "не определено" then "условия соблюдены" else a,{"Вид затрат"})