How to format (sort) csv for such a template?

Question

excel

Colleagues, hello everyone!
Please tell me how to solve the problem.
There is such a csv file
name |param | option
xCsw |qw,rt,we | 12,43,65
And we would like to get
name | qw | rt | we
xCsw |12 |43 |65
That is, "something" should take data from a cell and turn it into columns. Maybe there is some kind of CSV constructor?
Tell me what to pay attention to.
Thank you.

Answer 1

exists
but you can just take www.textpad.com,
press F8 , mark regexp
and replace | with \n
followed by - , with |