Table with Power Query

Hello good afternoon, how could I adapt this table with Power Query?


Thank you

Power Query(.planetaexcel.ru)
sotnikov

let
   from = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
   lst = List.Combine(Table.ToList(from,(x)=>List.Split(x,3))),
   tbl = Table.FromList(List.Select(lst,(x)=>x{0}<>null),(x)=>x),
   to = Table.Group(tbl,"Column1",{"Column2",each List.Sum([Column2])}),
    #"Changed Type" = Table.TransformColumnTypes(to,{{"Column1", type date}})
in
   #"Changed Type"

AlienSx

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    cols = Table.ToColumns(Source),
    dates = List.Combine(List.Alternate(cols, 2, 1, 1)),
    amounts = List.Combine(List.Alternate(List.Skip(cols), 2, 1, 1)),
    tbl = #table({"date", "amount"}, List.Zip({dates, amounts})),
    gr = Table.Group(tbl, "date", {"amount", (x) => List.Sum(x[amount])}),
    filter = Table.SelectRows(gr, each ([date] <> null)),
    #"Changed Type" = Table.TransformColumnTypes(filter,{{"date", type date}})
in
    #"Changed Type"

My option PQ

let
    Source = Excel.Workbook(File.Contents("C:\Users\seven\Documents\Documents\Pasta2(11).xlsx"), null, true),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Kind] = "Table") and ([Name] <> "Table2_2")),
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"Name", Order.Ascending}}),
    #"Expanded Data" = Table.ExpandTableColumn(#"Sorted Rows", "Data", {"Column1", "Column2"}, {"Column1", "Column2"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded Data",{"Column1", "Column2"}),
    #"Filtered Rows1" = Table.SelectRows(#"Removed Other Columns", each ([Column1] <> "Banco A" and [Column1] <> "Banco B" and [Column1] <> "Banco C" and [Column1] <> "Banco D")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows1", {"Column1"}, {{"Count", each List.Sum([Column2]), type number}}),
    #"Sorted Rows1" = Table.Sort(#"Grouped Rows",{{"Column1", Order.Ascending}})
in
    #"Sorted Rows1"