formula to pull data from one column and combine duplicates

This is probably something pretty easy and in excel I would use the consolidate function. I just need a formula to pull data from one column to another, but I need duplicate names left out

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!