Create a new table with unique records from database query table


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?




3 Replies
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