给你。

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcjYwMFRQ0lHyC/XxUYrVQQgYGhig8JEVGBEnYGJpiV+BKVYFsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Customer No" = _t, #"Ending Balance" = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,"NULL",null,Replacer.ReplaceValue,{"Ending Balance"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Replaced Value",{{"Customer No", type text}, {"Ending Balance", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Customer No"}, {{"All", each _, type table [Customer No=nullable text, Ending Balance=nullable text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.FillUp( Table.FillDown([All], {"Ending Balance"}), {"Ending Balance"})),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"All"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Ending Balance"}, {"Ending Balance"})
in
    #"Expanded Custom"

• • 步骤**

按如下方式对表进行分组：

添加自定义列，如下所示：

展开并删除冗余列，瞧。