Duplicate a column (Power Query)

Applies To
Excel for Microsoft 365 Excel for the web

When you want to make significant changes to a column, consider duplicating the original column and making your changes to the new column to help avoid refresh errors. Use the Duplicate Column command to create a copy of a column. For more information, see Handling data source errors (Power Query).

  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 (Power Query).
  2. Select the column that you want to duplicate.   
  3. Select Add Column > Duplicate Column.
  4. Consider renaming the new column. For more information, see Rename a column (Power Query).

See also

Power Query for Excel Help