Transpose stacked cell values into separate columns

BrianDN ✭✭
edited 02/24/23 in Formulas and Functions


Is there a way to split a stacked cell values into multiple columns with formulas?

So Col6 is the starting data that is dynamic, so it will change as forms are submitted so sometimes the cells have one name, sometimes they have 5.

I'm hoping the output would look like the below

Thanks for any help with this


  • BrianDN
    BrianDN ✭✭

    Hi Kelly,

    Yes, WOW, this is exactly what I need. This splits everything at carriage enter.

    Many thanks for this

  • BrianDN
    BrianDN ✭✭

    Hi Kelly,

    To piggy-back on this question, is there a "correct" way to append columns Col7-Col11?

    So that the end result would look like this:

    I would achieve this in excel via power query, but the only way I know how to do this in SmartSheet is essentially manually.

    Or should I post this as a new topic question?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!