Forum Discussion

heureso's avatar
heureso
New Member
7 years ago
Solved

Combine two list columns from same table

I have one table with two List columns.

 

Each List contains Records, and the Records from each column have the same fields.

 

I am trying to combine the two Lists for each row into a superset, then expand the Records from the combined column into new rows.

 

Any suggestions on how I might do that in Power Query?

 

I have tried just using the GUI to expand each List column to new rows sequentially, but then I end up with one row for each Record in the second List column for each Record in the first column. 

 

Thanks,

 

Jeremy.

 

 

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    heureso add custom column to combine both lists using following expression and then expand this new column, i believe that is what you are looking for

     

    List.Combine({[List1],[List2]})

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    Anonymous Use list.zip

     

    List.Zip({[List1 Column], [List2 Column]})

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi parry2k,

      Thanks for the reply.

       

      When I try using list zip:

      each List.Zip({[Lease Numbers List],[Size List]})

      It results in 3 rows but the result is just

       

      To clarify the columns within the List Zip have lists in each cell,

       

      Any additional thoughts?

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    heureso add custom column to combine both lists using following expression and then expand this new column, i believe that is what you are looking for

     

    List.Combine({[List1],[List2]})
    • heureso's avatar
      heureso
      New Member
      7 years ago

      Thanks so much, parry2k ! That was exactly what I was after. For some reason, I was making the problem much harder than it needed to be.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

      I have used List.Combine to Combine two lists.

      List.Combine({[Lease Numbers List],[Size List]})

       

      however it result in the lists being 'appended' on the bottom.

      What I am after as the prefered result is:


      Any suggestions?

      Thanks