I have a column like this
but I want to convert like this
how can I do this in ms excel?
With data in C1, in D1 enter:
=FILTERXML("<t><s>"&SUBSTITUTE(SUBSTITUTE(C1,"&","&"),",","</s><s>")&"</s></t>","//s")
2.1m questions
2.1m answers
57 comments
56.1k users