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