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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Greg_Deckler Sorry about that. Let's say the table I want to take the column from is called TableA and the Column from the table is called Col1. I want to copy that whole column to a new table (let's name it Table2). Is there a simple way to do that?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Well, if all you want in that Table2 is that column data, you can create a new calculated table in Power BI Desktop (not Power Query) and use SELECTCOLUMNS. SELECTCOLUMNS('TableA', "Col1", [Col1])