How to move data from an excel cell to unspecified number of rows

[parimala.prata (pari)]

I cannot thank you enough. This solution is working like a charm. Thank you for your help and assistance.