数据整理

wdx223

1. let
   
2.     Source = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
   
3.     #"Changed Type" = Table.TransformColumnTypes(Source,{{"物料", type text}, {"机型", type text}}),
   
4.     Custom1 = Table.Group(#"Changed Type","物料",{"n",each [a=[机型],b=List.Count(a),c=List.Transform({1..b},each "机型"&Text.From(_)),d=Table.FromRows({a},c)][d]}),
   
5.     Custom2 = Table.ExpandTableColumn(Custom1,"n",Table.ColumnNames(Table.Combine(Custom1[n])))
   
6. in
   
7.     Custom2

复制代码