...just seen the requirement to list the unique values.

So using my previous suggestion copy the column A values into Column K. Then select the column K range and use the 'Remove Duplicates' functionality in the Data Tools area of the ribbon.

Then copy R4 down as necessary