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, t...
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]})
parry2k's avatar
parry2k
Icon for Super User rankSuper 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