Forum Discussion
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?...
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