Formula to migrate data from a sheet to another with hierarchy separation

Options

HI,

What formula would work to move text data from a sheet in which the Primary Column has multiple ancestor entries and multi-level children and in the secondary sheet, I want to expand those into each level of child in a new row to work with.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!