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.