let
Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Surname", type text}, {"Org", type text}, {"Title", type text}, {"Team 1", type text}, {"Skill 1", type text}, {"Skill 2", type text}, {"Skill 3", type text}, {"Skill 4", type text}, {"Skill 5", type any}, {"Skill 6", type text}, {"Skill 7", type any}, {"Skill 8", type any}, {"Gender", type text}, {"In Contract", type any}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Name", "Surname", "Org", "Title", "Team 1"}, {{"Count", each _, type table}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Skill 1", each List.Distinct(Table.Column([Count],"Skill 1"))),
#"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Skill 1", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom1" = Table.AddColumn(#"Extracted Values", "Skill 2", each List.Distinct(Table.Column([Count],"Skill 2"))),
#"Extracted Values1" = Table.TransformColumns(#"Added Custom1", {"Skill 2", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom2" = Table.AddColumn(#"Extracted Values1", "Skill 3", each List.Distinct(Table.Column([Count],"Skill 3"))),
#"Extracted Values2" = Table.TransformColumns(#"Added Custom2", {"Skill 3", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom3" = Table.AddColumn(#"Extracted Values2", "Skill 4", each List.Distinct(Table.Column([Count],"Skill 4"))),
#"Extracted Values3" = Table.TransformColumns(#"Added Custom3", {"Skill 4", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom4" = Table.AddColumn(#"Extracted Values3", "Skill 5", each List.Distinct(Table.Column([Count],"Skill 5"))),
#"Extracted Values4" = Table.TransformColumns(#"Added Custom4", {"Skill 5", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom5" = Table.AddColumn(#"Extracted Values4", "Skill 6", each List.Distinct(Table.Column([Count],"Skill 6"))),
#"Extracted Values5" = Table.TransformColumns(#"Added Custom5", {"Skill 6", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom6" = Table.AddColumn(#"Extracted Values5", "Skill 7", each List.Distinct(Table.Column([Count],"Skill 7"))),
#"Extracted Values6" = Table.TransformColumns(#"Added Custom6", {"Skill 7", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom7" = Table.AddColumn(#"Extracted Values6", "Skill 8", each List.Distinct(Table.Column([Count],"Skill 8"))),
#"Extracted Values7" = Table.TransformColumns(#"Added Custom7", {"Skill 8", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom8" = Table.AddColumn(#"Extracted Values7", "Gender", each List.Distinct(Table.Column([Count],"Gender"))),
#"Extracted Values8" = Table.TransformColumns(#"Added Custom8", {"Gender", each Text.Combine(List.Transform(_, Text.From), " "), type text}),
#"Added Custom9" = Table.AddColumn(#"Extracted Values8", "In Contract", each List.Distinct(Table.Column([Count],"In Contract"))),
#"Extracted Values9" = Table.TransformColumns(#"Added Custom9", {"In Contract", each Text.Combine(List.Transform(_, Text.From), " "), type text})
in
#"Extracted Values9"
