Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How To Copy a Column from One Table to a New Table

I have a column in one table I am trying to copy over to a new table. I do not have existing relationships and there is no 'index' column in my original table.    How do I copy that one column over...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    In data view, you could copy column or copy table. then paste it.

    1.copy column.

    2.paste it.

    3.or in table b ,you could paste in power query.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous You could use LOOKUPVALUE or MAXX(FILTER

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Greg_Deckler Thank you. I can't seem to figure out LOOKUPVALUE... let's say I have a table and column like so: TableA[Col1]... what is the proper command to copy this column into the new table?