Use Excel's Get & Transform (Power Query) experience to add new columns of data in the Query Editor by simply providing one or more sample values for your new column. You can create a new column example from a current selection, or from providing input based on all (or selected) columns in a given table. Learn more at the Excel Help Center: https://support.office.com/excel
Copilot
VIDEO
3 January 2019
Add a column from an example in Excel
Use Excel's Get & Transform (Power Query) experience to add new columns of data in the Query Editor by simply providing one or more sample values for your new column. You can create a new column example from a current selection, or from pro...
