Required mix data format as organized data formats

You can use Text to column feature to separate this data
Select Delemited and under Delimiters use comma and next
select destination and almost your data looks like
and for the 3rd and 4th column you can again use this method.