Data to transfer from column to row

Q

qwerty70

Dear All,

I have a cell that contains like:

PM-1234, PM-2345, PM-5689, PM-9999. I want to segregate these 4 tag
into rows.

i.e.,
PM-1234
PM-2345
PM-5689
PM-9999

Is there any excel guru out there to help in my problem???

Your help is greatly appreciated.

Thank you,

qwerty7
 
Top