问题:将“数据”列分组向下填充
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
分组 = Table.Group(源, {"编号"}, {"内容", each Table.FillDown(_,{"数据"})}),
展开 = Table.ExpandTableColumn(分组, "内容", {"数据"}),
更改的类型 = Table.TransformColumnTypes(展开,{{"编号", type text}, {"数据", Int64.Type}})
in
更改的类型
标签:Power,填充,分组,Table,Query,向下 From: https://www.cnblogs.com/officeplayer/p/17300619.html