|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
= Table.Combine(Table.Group(已添加自定义,"a",{"分组",each [a=List.Accumulate([列1],{},(x,y)=>if Text.Contains(y,":") then x&{y} else List.FirstN(x,List.Count(x)-1)&{List.Last(x)&y} ),b=List.Select(a,(m)=>List.AnyTrue(List.Transform({"款号","面料","里料","维护","注","纤维","成分"},(n)=>Text.Contains(m,n)))),c=Table.PromoteHeaders(Table.FromColumns(List.Transform(b,(p)=>Text.Split(p,":")))) ][c]},0,(c,v)=>Byte.From(v<>null))[分组])
大神,能帮忙解答一下这个公式里每个步骤的意思嘛? |
|