高手大侠们求助，谢谢

cnmlgb9998

1. let
   
2.     源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
   
3.     更改的类型 = Table.TransformColumnTypes(源,{{"列1", type any}, {"列2", Int64.Type}, {"列3", Int64.Type}, {"列4", Int64.Type}, {"列5", Int64.Type}, {"列6", Int64.Type}}),
   
4.     筛选的行 = Table.SelectRows(更改的类型, each try not Text.Contains([列1],"M") otherwise true),
   
5.     已添加自定义 = Table.FromColumns(List.Skip(List.Accumulate({1..Table.ColumnCount(筛选的行)},{{}},(x,y)=>x & {List.Sort(List.Distinct(List.RemoveNulls(List.ReplaceValue(Table.Column(筛选的行,"列"&Text.From(y)),"",null,Replacer.ReplaceValue))))})))
   
6. in
   
7.     已添加自定义

复制代码