Look at column in table, remove duplicates and sort to another table

I have a list of parts in a table. I am manually copy/pasting this list to another sheet in my workbook and then using DATA→Remove Duplicates to get a shortened list. Is there a way to automate this process?

In the attached workbook I want the yellow cells to auto-fill for me.

I get a lot of lists in the format on the left hand side so I want excel to automatically format them for me so that I can use the output on the right.

try
=IFERROR(INDEX($A$4:$A$70,MATCH(0,INDEX(COUNTIF($F$3:F3,$A$4:$A$70),0,0),0)),"")
and use CONTROL+SHIFT+ENTER to get an array formula {}