CSV file with two columns multiple values separated by pipe. Need to Combine

Hello,

I have a CSV file with two columns. One "Sizes" and second "Stock" both with multimple values like L|M|S|XL|XXL and 17|16|11|21|18. I have to combine those column in a new column like this:

L:17|M:16|S:11|XL:21|XXL:18

Can anyone help me to do that?

Also i want to calculate sum of stock. That means a new column " Total Stock" and make a sum with all values separated by pipe |

I attached the file.

God bless you and your family.