Adding a value in a new column for a specific number of rows based on the value of single row?

Can you provide a reproducible example? It will make easier to work out what you are trying to do: