There is a simple method, because there is no duplicate value in the data in the filter directory, as long as you use the function of deleting duplicates in excel, the specific operation steps are as follows:

Select the cell column of the table of contents to be extracted, and copy and paste it into another newly created table.

Select all the pasted data, click Data in the menu bar, and then click Delete Duplicates.

In the pop-up window, select Sort by Current Selection, and then click Delete Duplicates.

The "Delete Duplicates" window pops up again, and click "Delete Duplicates".

In this way, all data become unique data.