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!
Help Article Resources
Check out the Formula Handbook template!