Split Data in one cell into below rows

[Ctrl+s]

Greetings,

Can any one help on this below situation.

I have data in two Columns one Columns contains data with different line in each cell

like

MR X
MR Y
MR Z

and in the other column with single line like

Success
Failed

Please see the below image for clear view.



In this case, I want to split the data in to each line in to each row.

Like MR X Failed
Mr Y Failed
Mr Z Failed and so on..

Can anybody has an Idea to solve my problem with a Macro?

Thank you in Advance.

Best Regards,