How to populate all the rows in one column based on one cell value

[snb]

@Doc

You missed the one-liner that suffices ?

I find commented code too much pain to read: I prefer the comments to be separated from the code entirely.
But: the simpler the code the less commentary is needed (see my one-liner).
Ergo: prevent the need for comments by 'bare' coding (instead of 'clumsy coding')

[DocAElstein]

Hi snb

You missed the one-liner that suffices ?.)

No I didn't. it was my favourite : It is in the first code window: - you have to scroll down. - Just like to see the 'comments you mostly have to scroll to thje right, so its up to you if you want to see them or not. There is loads of room there. I find it a great place to store my notes. ( EDIT: I just moved the comments a bit more to the right for you in my code )
But everyone to their own...

...
I find commented code too much pain to read:......

I thought you would like it