Help in preparing order summary

Welcome to the forum. Here is a solution using Power Query, with the following M Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Order-delivery-time", "Item1-name_reward_type_quantity_price+Variants+Addons", "Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Removed Other Columns", {"Order-delivery-time"}, "Attribute", "Value"),
    #"Filtered Rows" = Table.SelectRows(#"Unpivoted Other Columns", each ([#"Order-delivery-time"] <> null)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Attribute"}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Removed Columns", "Value", Splitter.SplitTextByDelimiter("_", QuoteStyle.Csv), {"Value.1", "Value.2", "Value.3", "Value.4"}),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Split Column by Delimiter", "Value.4", Splitter.SplitTextByDelimiter("+", QuoteStyle.Csv), {"Value.4.1", "Value.4.2"}),
    #"Renamed Columns" = Table.RenameColumns(#"Split Column by Delimiter1",{{"Order-delivery-time", "Date"}, {"Value.1", "Item Sold"}, {"Value.3", "Qty"}, {"Value.4.1", "Amount"}, {"Value.4.2", "FOC Item"}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Renamed Columns",{"Value.2", "FOC Item"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns1",{{"Date", type date}, {"Qty", Int64.Type}, {"Amount", Currency.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Date", Order.Ascending}, {"Item Sold", Order.Ascending}}),
    #"Grouped Rows" = Table.Group(#"Sorted Rows", {"Date", "Item Sold"}, {{"Total Qty Sold", each List.Sum([Qty]), type nullable number}, {"Total Amount", each List.Sum([Amount]), type nullable number}})
in
    #"Grouped Rows"

Thanks for helping out. Sry for the layman question. How to run this query. I am used to macro actually.

I am not sure about Excel for Mac, but for me > Data > Show Queries > right-click query > Edit.

You don't run the query.. you right click on the table and select Refresh whenever new data are added.