let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
Type = Table.TransformColumnTypes(源,{{"户号", type text}}),
Group = Table.Group(Type,"户号",{"A",each Table.AddColumn(_,"家庭类型",(t)=>if List.Contains(_[健康状况],"残疾") then "残疾家庭" else "健康家庭") }),
Expand = Table.ExpandTableColumn(Group, "A", {"关系", "姓名", "健康状况", "家庭类型"})
in
Expand
10357101820264.rar
(98.94 KB, 下载次数: 0)
|