I have two sql columns each with delimited data that I want to collate and combine into a single delimited column. The number of items in the column is variable for each row. However there will always be a matching number of items between the two columns of each row. For Example...

```
*******************************
ORIGINAL SQL TABLE
*******************************
value          *    unit
*******************************
4 ; 5          *   mg ; kg
50             *   mg
7.5 ; 325      *   kg ; mg
100 ; 1.5 ; 50 *   mg ; g ; mg
********************************

*********************************
DESIRED SQL RESULT
*********************************
value-unit
*********************************
4 mg; 5 kg
50 mg
7.5 kg; 325 mg
100 mg; 1.5 g; 50 mg
*********************************

```

How do I do this with T-SQL? I'm using SQL Server 2012