Creating new column eliminating some names with conditions

[arikofather]

Transform Contacts.pbix

I have a simple table with list of names.  Some have email addresses instead of names.

I need to create a new colum of attendees to only select names and not those with email addresses.  Result column should be  as below:

Can anyone help with the calculalated column?

Thank.

[ThxAlot · Accepted solution]

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dY/NCoJQEIVf5eI6eoG70Yz+RBJaiotRJx28zsRcK3z7wiAKa30+vnNOngcrKc0OnLNbxcakosjVaPdKTCYhbuwaSpNdFe/g7AldOZqoI/b2lGWZSRGHJxQUizyIuFYalxtw0kuYEuOykt6mVLWAzsQK9MuW0IA6tx2EYWiBTSy+F/8Fn9EplIRhjTfhC2gH9Y28qJ8aP8bPtP867SudroXHl2eeR2/AT0hQFA8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Attendees = _t]),
    #"Removed email" = Table.AddColumn(Source, "Result", each Text.Combine(List.Select(Text.Split([Attendees], ";"), each not Text.Contains(_, "@")), ","))
in
    #"Removed email"

[wini_R]

Hi @arikofather ,
Is power query solution OK to you? If so, please paste the code below in the Advanced Editor:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dc9NDoJADAXgq0xcGy8wGxTjb4gkLAmLAhUahtZ0UMPtRUyMBt32NV9f03S25FKpX2zASStBRIyLQlobUVEDOhMqUGXXkJv4qngHZxN0eW+O1KHaJI5jEyF2xNUsmw9asmyIfXDy3j+dcbiS3OzAObtVrEwkilz0dq/ENDj8ix+VKX8Qhq4GNqH4VvxXlzM6hZwwKPEmfAFtoLyRFx2LfJ6bsO/S4+ZnbF/5n5eHNHsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Attendees = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Attendees Clean", each Text.Split([Attendees], ";") ),
    #"Expanded Attendees Clean" = Table.ExpandListColumn(#"Added Custom", "Attendees Clean"),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Attendees Clean", each ([Attendees Clean] <> "" and not Text.Contains([Attendees Clean], "@"))),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Attendees"}, {{"Attendees Clean", each _[Attendees Clean] }} ),
    #"Extracted Values" = Table.TransformColumns(#"Grouped Rows", {"Attendees Clean", each Text.Combine(List.Transform(_, Text.From), ";"), type text})
in
    #"Extracted Values"