Create Table from Unique Values in Other Table

Hi! A bit surprised I haven’t been able to find an answer for this, or figure it out myself.

I have a table that has duplicate values in one column. I want to return all unique values from that column into a new column in a different table within the same base. Ideally, I’d like the column in the new table to be the Name column.

How can I do this?

Thanks!