先合并文件夹下的全部需要合并的7个表,然后透视列,搞定!!!
let
源 = List.Transform(Folder.Files("C:\Users\zmh\Desktop\范例文件")[Content],each Excel.Workbook(_,true){0}[Data]),
合并表 = Table.Combine(源),
透视列 = Table.Pivot(合并表, List.Distinct(合并表[partnb]), "partnb", "actual", List.Sum)
in
透视列 |