Text to Rows

[Jonny]

Hi guys, i'm really hoping someone can help me as i'm very new to Excel.
I have a .csv file with around 200 rows and 4 columns (SKU, SIZE, TITLE, QTY)

Basically the SIZE & QTY columns are pipe delimited for example 36|38|39|40 1|3|2|1

So for size 36 there is 1 in stock, 38 there is 3 etc etc

What i would like to do is somehow create a new row for each variation copying the SKU & TITLE and separating the delimited values, putting the SIZE & relevant QTY into that row.

I would greatly appreciate any help.

Thanks in advance