用PQ，按日期对数量和金额转一维，怎么操作

jhjdcg

用PQ，按日期对数量和金额转一维，怎么操作，数据和想要的结果举例见附件。

windgod489

let
    源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    Transpose = Table.FillDown(Table.Transpose(源),{"Column1"}),
    Promote = Table.PromoteHeaders(Transpose),
    Unpivot = Table.SelectRows(Table.UnpivotOtherColumns(Promote,{"产品名称","Column2"},"Data","Schame"),each Text.EndsWith(_[产品名称],"日")),
    Result = Table.RenameColumns(Table.ReorderColumns(Table.Pivot(Unpivot,{"订单数量","金额"},"Column2","Schame"),{"Data","产品名称"}),{{"Data","产品名称"},{"产品名称","日期"}})
in
    Result

强扭的瓜更甜

jhjdcg

收到，谢谢楼上二位

hbzql

let
    源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    自定义1 = Table.RemoveFirstN(Table.FromColumns(List.Transform(List.Split(Table.ToColumns(源),2),each List.Zip(_)),{"产品名称"} & List.RemoveNulls(List.Skip(Table.ToRows(源){0},2))),2),
    自定义2 = Table.TransformColumns(Table.UnpivotOtherColumns(自定义1,{"产品名称"},"日期","值"),{"产品名称",each _{0}}),
    自定义3 = Table.SplitColumn(自定义2,"值",each _,{"订单数量","金额"}),
    自定义4 = Table.Combine(Table.Group(自定义3,"日期",{"分组",each _})[分组])
in
    自定义4