Repeat cell until new value is reached

I need a column formula that will repeat cell contents until a new value is reached, then repeat those cell contents until a new value is reached, and on and on.

I want it to look like it does in this example for Column19 where the department is repeated until there is a new listing.

Any help is appreciated!


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!