Mearns Learns

Table Mountain built with blocks

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.

Reference Reference

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

Choose columns Choose columns

Right click on the column heading and select Remove Duplicates.

Remove duplicates Remove duplicates

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