Summarize by different column when blank

Hi John1234 

you can take steps below for reference.

1. Open the Advanced editor:

2. Empty the contents in the Advanced editor, and copy the following code into it

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkxJKUotLjZU0lFKzU3MzDFUitXBFDUCi8J4xig8E2QdpjBRU6XYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Address = _t, Email = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Address", type text}, {"Email", type text}}),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Address] <> "")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Address"}, {{"Email", each Text.Combine([Email],", "), type  text}}),
    table1= Table.SelectRows(Source, each ([Address] = "")),
    #"appendtable"=Table.Combine({table1, #"Grouped Rows"})
in
    #"appendtable"

Result:

Hope this helps.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.