For example all of the following to the left of the : are the header of a column and to the right of the : are the data in one single cell.

Size: 5,6,7,8,9,10
Quantity: 11,22,33,44,55,66
Price Increase: 0,0,0,0,0,0
Additional Weight: 0,0,0,0,0,0
Sort Order: 1,2,3,4,5,6

How would you format this into a new column/cell to display it as the following which is SIZE:QUANTITY:PRICE INCREASE:ADDITIONAL WEIGHT:SORT ORDER|SIZE:QUANTITY:PRICE INCREASE:ADDITIONAL WEIGHT:SORT ORDER and so on...

5:11:0:0:1|6:22:0:0:2|7:33:0:0:3|8:44:0:0:4|9:55:0:0:5|10:66:0:0:6

I am at a loss. Look forward to receiving your help.