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.

Prevent duplicates before they happen by combining a simple function with data validation. Excel has built-in tools to expose and even delete duplicates, but they work on existing data after the fact.