Split and Concatenate List Items in Two Seperate Columns

[FrankSourced]

Hi All,

There may be an easy solution to this but I haven't come up with it.   I have two comma delimited fields that come in via Shopify for my orders.   The first is line items of the order, the second is quantities of each line item.

There can be 4-5 line items in an order and quantities of each line item can be between 1-5.

I would like to split the two columns above and then concatenate like-for-like.  So in the example above I need a new virtual column that reads:

1X Hibiscus Vodka Cooler - Ketel One / 375ml Bottle - 8 & 1X Cocktails,Watermelon Basil Margarita - 375ml / 6 Cocktails

Any help is appreciated!!!