how to split vertial data into saperate cells

[cheekugreat]

Hi,
i have a data on following pattern

and want to split it into multiple rows like this.

please guide if these's any function or formula to do this task.
thanks.

 

[maxie]

Hi Welcome to Seven Forums ... Read the Link below ...


Merge and unmerge cells - Excel

 

[cheekugreat]

doesn't help.