Moving Rows Columns

[Nick555]

I have a SharePoint Online list that I am working with. One of the fields is an Assigned Person field. I have been able to get it into a table of just IDs and the assigned people, following the structure of Table 1 below. I am trying to get it to be like Table 2 below.

I’ve found a couple of postings that seem to deal with similar situations, but they just don’t seem to work. Some of the steps they list will not have the same options I am given when I follow their steps.

Any help would be greatly appreciated. Thx

[Fowmy · Accepted solution]

@Nick555 
Create a blank Query, go to the Advanced Editor, clear the existing code, and paste the codes give below and follow the steps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUQpILSrOz1NIVIrViVYyQggkgQWMEQLJYAEThEAKWMAUj0AqWMAM3RZzdC0W6NZaoGuxRNdiaIBiTSwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Person = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Person", type text}}),
    #"Grouped Rows" = 
    
    Table.Group(
        #"Changed Type", 
        {"ID"}, 
        {
            {"all", each  Text.Combine(List.Transform([Person], Text.From), "|")}
        }
    ),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Grouped Rows", "all", Splitter.SplitTextByDelimiter("|", QuoteStyle.Csv), {"all.1", "all.2"})
in
    #"Split Column by Delimiter"

Result