Transpose vertical rows into one horizontal cell

mmac ✭✭✭✭✭


I'm having trouble trying to transpose vertical rows which once text is populated, and have it appear in a horizontal fashion in a designated cell. I can manually make this happen, but wish to input a formula that manipulate the data like this each time a new row is added. I'm wondering if in this case, it would be best to first indent the bundle step rows as child rows underneath the parent row bundle cat ID.

Thank you in advance for anyone that is able to support.

Video of what I am trying to accomplish is here for reference.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!