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

[jmishra]

Hi DocAElstein, Your solution works perfectly. Your detailed explanation is very helpful and easy to understand.