Use the Duplicate command to copy a column. If you want to make significant changes to a column, it’s a good idea to duplicate or copy the original column, and make your changes to the new column, so you don’t inadvertently cause refresh errors down the road. For more information, see Handling data source errors.

  1. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.

  2. Select the column for which you want to make a copy.   

  3. Select Add Column > Duplicate Column.

    You probably want to rename the new column. For more information, see Rename a column.

See Also

Power Query for Excel Help

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!