The specific steps are as follows:
Select the column of cells that need to extract the same data.
use the "highlight duplicates" function of "duplicates" in excel, which can fill the same data with the same background color.
use the "filter" function in excel to filter out the data with the same color background.
just copy and paste the filtered data into another table.