How to append columns of data



I'm hoping to append multiple columns into 1 (so "stack" them).

In this case the first 5 columns would result in the Append column as shown below:

Normally I'd use Power Query in Excel but how can we achieve this in SmartSheets.

Thanks for any help with this

Best Answer

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭
    Answer ✓

    The main problem is that a column formula will only extend to populated rows. You could technically add another column which is just a list of number (1,2,3, etc, as many as you need). Then you could use a formula like this:

    =INDEX(COLLECT([Col15]:[Column18], [Col15]:[Column18], NOT(ISBLANK(@cell))), [NumberedRowColumn]@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!