How to filter unique data from a Column having multiple duplicate values.?

I have column with various duplicate values e.g. Duplicate Transaction ID, Duplicate name in Column

I want to segregate unique records from that column and display in another sheet/column

please guide how to do so ?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!