Forum Discussion

kevinEGE's avatar
kevinEGE
Regular Visitor
3 years ago

Table with two list

Good afternoon!

 

I have a table with two columns in list format, one for contacts and the other for files. I want to expand both columns to see the data. How can I do this? If I use the built-in Power Query tool to expand them, it will create one row for each contact with a file. Since it's possible to have more than one contact and file (up to 3 or 4 contacts and/or files), this would create a very large table.

 

Thank you so much!

Need Help
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    kevinEGE , create a new column

    using two list columns

    Zip=

    let

    _break = List.Zip( {[COlumn1], [COlumn2]} ),
    _Trans = List.Transform(_break, each Record.FromList(_, {"Subject", "Marks"}))
    in
    _Trans

     

    and then expand record

     

    Table.ExpandListColumn(#"Added Custom", "Zip")

     

    next step

    Table.ExpandRecordColumn(#"Expanded Zip", "Zip", {"Subject", "Marks"}, {"Zip.Subject", "Zip.Marks"})