Again:

I have this list

i want make like this


Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @ilyas star ,

    I don't have a solution for you. Smartsheets doesn't have a transpose function. You could use SUBTITUTE to replace the "," with CHAR(10) which will generate a hard return but your results will all be in the same cell.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!