问题:多工作表合并,但第一行不需要,标题行从第二行起。
let
源 = Excel.Workbook(File.Contents("路径\文件名.xlsx")),
规范表 = Table.TransformColumns(源, {"Data", each Table.PromoteHeaders(Table.Skip(_,1))}),
删除列 = Table.SelectColumns(规范表,{"Data"}),
展开 = Table.ExpandTableColumn(删除列, "Data", {"列1", "列2", "列3"})
in
展开
标签:第一行,多表,Power,Table,Query,Data From: https://www.cnblogs.com/officeplayer/p/17300729.html