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.