Forum Discussion

s15's avatar
s15
Icon for Helper III rankHelper III
9 years ago
Solved

Copy two columns to a new table

Hi all,   I have a sample dataset like the one below     What I need is to create a new table then copy Sales and Years column to this table. The purpose is that I will need to pivot Years...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    s15 in power query just  right click table and duplicate and remove columns you dont need

RodrigoMachado's avatar
RodrigoMachado
Frequent Visitor
5 years ago

Hi calerof  yes, when you duplicate a table its source remains the same, so when you edit your database your duplicated table will be edited as well.

calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
5 years ago

RodrigoMachado ,

Thank you for your kind response. Nobody bothered for almost 2 years. 

Now I got it clearer.

Cheers,

Fernando