|
- let
- Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
- #"Changed Type" = Table.TransformColumnTypes(Source,{{"姓名", type text}, {"所属组别", type text}, {"销售量", Int64.Type}, {"组内排名", type text}}),
- #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"销售量"}),
- #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[组内排名]), "组内排名", "姓名"),
- Custom1 = List.Distinct(Source[所属组别]),
- Custom2 = Table.Sort(#"Pivoted Column",each List.PositionOf(Custom1,[所属组别]))
- in
- Custom2
复制代码 |
|