Create a new table with unique records from database query table

Brass Contributor

Given: Excel 2016

 

I have a database query that loads a table on my worksheet and it gets updated frequently. How can I create a table next to it that lists the unique names in the database table?

 

rodsan724_1-1635381339012.png

 

3 Replies
Hi
Either create a new query based on the database query or use SORT(UNIQUE(Name)).
I'm in Excel 2016, I don't think UNIQUE is available in this version.
If you only need a list of those item and no other columns besides it, try Pivot. It would not be heavy on the sheet as well