How to repeat a variable value in a column?

[smith Jason]

Hello, I have a small dataset below,
clear
input str80 name str90 symbol
"F-000509" "Environmental Projects4502 - Parks Consolidated Construction Fund"
" " "Future Bond Election "
"F-000703" "Swimming Pool Upgrades"
" ""4502 - Parks Consolidated Construction Fund"
" ""Future Bond Election"
"F-000708" "Parking garage Upgrades"
end

I want to repeat the value of the first column "name" to fill the gap between the name values.
This is just for illustration.
In fact, the real dataset has many name values and the gap between name values is unequal.
Thanks for your help with the Stata code.

[Nick Cox]

This is an FAQ

https://www.stata.com/support/faqs/d...issing-values/

[smith Jason]

Thank you!
I try the two commands below, however, they don't work.
replace name = name[_n-1] if name == ""
replace name = name[_n+1] if missing(name)

[Nick Cox]

It looks as if you have spaces there,not empty strings.

replace name = name[_n-1] if trim(name) == ""

[smith Jason]

Thank you!