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!

Turn the column with duplicate values into a LinkToAnotherRecord type field, ‘point’ it at a new table.

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.