The new column will create an incrementing integer which is basically a pointer to the row number of the results. To do this in MS SQL Server, add the following to the beginning of your column ...

This option only appears if Excel detects data adjacent to the selected column. Uncheck all columns except the one containing the consolidated data and click "OK" to remove duplicates.