Concatenate VBA solution

Hi Walesm3011,

Assuming your table starts at cell A1, the following code will generate the 4212 possible entries in column "J".

Sub concatenate()
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim l As Integer
Dim m As Integer

i = 1

For k = 2 To 7
For j = 2 To 14
For l = 2 To 10
For m = 2 To 7
Cells(i, 10) = "c." & "1." & "1." & Cells(j, 4).Value & "." & Cells(k, 5).Value & "." & "0." & Cells(l, 7).Value & "." & Cells(m, 8).Value
i = i + 1
Next m
Next l
Next j
Next k

End Sub