Consolidate Multiple Column Cells Into 1 Based on Cell Value in Row

I am working on a telecom cleanup project and have an export of all the telephone numbers at each site. I'm wanting to take the telephone numbers in each cell and combine them into 1 based on the branch number. The closest thing I could figure out was to run a collect function based on the branch number but am getting an incorrect argument error. Anyone know a formula that would work for this?

=INDEX(COLLECT(WTN:WTN, [Branch Number]:[Branch Number] = "FL24"))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!