how to convert excel column data to row data

Question

I have a column like this

but I want to convert like this

how can I do this in ms excel?

Answer 1

With data in C1, in D1 enter:

=FILTERXML("<t><s>"&SUBSTITUTE(SUBSTITUTE(C1,"&","&amp;"),",","</s><s>")&"</s></t>","//s")