How can I "transpose" multiple columns into one column with multiple rows?

I am looking to convert multiple columns of data into a row per column populated. A bit like "transpose"

So as follows:

Automation doesn't seem to give me the flexibility to be able to do this.

Any ideas?

Thanks in advance

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!