Skip to content

Instantly share code, notes, and snippets.

Created August 19, 2020 16:38
What would you like to do?
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Mix", type text}}),
#"Added Custom" = Table.AddColumn(
#"Changed Type",
each Text.Combine(List.RemoveNulls(List.Transform(Text.ToList([Name]),
each if Value.Is(Value.FromText(_), type number) then _ else null))))
#"Added Custom"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment