As a result, even seasoned Excel users often find themselves stuck doing tasks ... It took me some time to know that we can easily remove duplicates and extract unique values using the UNIQUE ...

Again, once I've checked that this formula produces the expected result, I can use the fill handle to duplicate it to the remaining cells in column D. There are other ways in Excel to extract data ...