Create a new table from an existing table

The following steps detail how to create a new table displaying only unique values from an existing table.

In the Power Query editor, right click on the query that you want to use a source.

Select Reference.

On the Home menu, click on Choose Columns to select the column that you want to keep.

Right click on the column heading and select Remove Duplicates.

Sort the column into the order that you want to use.