let
Source = Table.Combine( Excel.Workbook(File.Contents("E:\СЫр.xlsx"), null, true)[Data] ),
Combine = Table.SelectColumns(Source,{"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10"}) & Table.Skip( Table.DemoteHeaders( Table.SelectColumns(Source,{"Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21"}) ), 1 ),
AddedIndex = Table.AddIndexColumn(Combine, "Индекс", 1, 1),
GroupIndex = Table.AddColumn(AddedIndex, "Пользовательская", each if Text.StartsWith( Text.Combine({[Column3], ""}), "Паспорт варки сыра") then [Индекс] else null),
FilledDown = Table.FillDown(GroupIndex,{"Пользовательская"}),
FilteredRows = Table.SelectRows(FilledDown, each ([Пользовательская] <> null)),
Isolation = Table.Group(FilteredRows, {"Пользовательская"}, {{"Tab", each Table.FromColumns( { {_{2}[Column3]}, {_{1}[Column3]}, {_{32}[Column4]}, {_{32}[Column5]}, {_{7}[Column5]}, {_{13}[Column5]}, {_{13}[Column4]}, {_{13}[Column5]}, {_{16}[Column5]}, {_{16}[Column6]}, {_{16}[Column7]}, {_{16}[Column8]}, {_{16}[Column9]} }, List.FirstN( Table.ColumnNames(Шаблон), 13) ), type table}}),
Custom1 = Table.Combine( Isolation[Tab] )
in
Custom1 |