Split multiple values in a cell to multiple rows

Hello All,

I am new to this forum, and wanted to know, if there is a way to split multiple values in a cell to multiple rows. example check the attached sheet, please suggest a macro/function with in excel etc. appreciate your help in this regard.


Thanks,
Karthik