List to column

Hi vishnusingh ,

This:

let
    Source = Table.FromRecords({
    [ip =  "192.168.1.1"],
    [ip = Table.ToList(Table.FromRecords({[ip = "10.168.1.2"],[ip = "10.168.1.3"]}))],
    [ip = "22.168.1.4"]}),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each if Type.Is(Value.Type([ip]),type list) then [ip] else {[ip]}),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    #"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"ip"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "ip"}})
in
    #"Renamed Columns"

Best Regards

Community Support Team _ chenwu zhu

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