Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combine data from 2 tables into a single column

I have 2 tables: Table1:                Table2: COL1                   COL2 A                           1 B                           2 C                           3   I want to create a new t...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try new table like

    new table =

    Union (all(Table1[col1]),all(Table2[col2]))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try new table like

new table =

Union (all(Table1[col1]),all(Table2[col2]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks amitchandak  that worked.