What formula could I use to nest automatically based on primary column?



Trying to make it so that information in columns b-f automatically nest under the names in column a instead of doing it manually as I have a large amount of data. For example, John Doe has a badge with two different types of access. I need those to nest under them while John Smith's access information nests under their name if that makes sense? I was thinking it would be some type of IF function but nothing I've tried has worked.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!