Mail merge nested if statements

RichardOlin 

In what application is the data?  If you have it in an Excel Workbook and you run a macro containing the following code

Dim shtsource As Worksheet
Dim shttarget As Worksheet
Dim c As Long, r As Long, rowtarget As Long, c1 As Long
Set shtsource = Sheets(1)
Set shttarget = Sheets.Add
For c = 1 To 5
shttarget.Range("A1").Offset(0, c - 1) = shtsource.Range("A1").Offset(0, c - 1)
Next c
shttarget.Range("A1").Offset(0, 5) = "Wish Item"
rowtarget = 1
With shtsource.Range("A1")
For r = 1 To .CurrentRegion.Rows.Count - 1
For c = 1 To 6
shttarget.Range("A1").Offset(rowtarget, c - 1) = .Offset(r, c - 1)
Next c
rowtarget = rowtarget + 1
For c1 = 7 To 12
If .Offset(r, c1 - 1) <> "" Then
For c = 1 To 5
shttarget.Range("A1").Offset(rowtarget, c - 1) = .Offset(r, c - 1)
Next c
shttarget.Range("A1").Offset(rowtarget, 5) = .Offset(r, c1 - 1)
rowtarget = rowtarget + 1
End If
Next c1
Next r
End With

It will add a sheet to the workbook with the data re-arranged as shown below which can then be used as the data source for a straight forward Label type mail merge