Multiple values in a row - split into separate row

[sebastiank88]

Hello,

Can somebody knows how to resolve this problem?

I got an excel file which got sheet 1 and sheet 2. I want to merge sheet 1 and sheet 2 into one csv file.

As you can see values are stored in one cell.

Is it possible to split those value into separate cell like below?

Final view

Best Regards,

Sebastian

[binuacs]

@sebastiank88 one way of doing this

[sebastiank88]

Thank you, it's working :)