In the example shown, the color field has been added as a row field.
The resulting pivot table (in column D) is a one-column list of unique color values.
This allows the Pivot Table to always show the latest list of unique values (after refresh).
Pivot table list unique values
To extract a list of unique values from a data set, you can use a pivot table. In the example shown, the color field has been added as a row field. The resulting pivot table (in column D) is a one-column list of unique color values.
