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 providing input based on all (or selected) columns in a given table. Learn more at the Excel Help Center: https://support.office.com/excel