Convert formula to values and wrap text automatically

Hi

At "BuildMaster" sheet, when user updates hostname and IP address, automatically concatenate at column F12.

Would like to incorporate the below formula at Column F and then convert to value and also would like to automatically merge column D and Column F after double click the last row in macros.
=IF(BuildMaster!$B12<>"",BuildMaster!$B12&" "&CHAR(10)&BuildMaster!$C12,"")

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim LR As Integer
If Target.Column > 1 Then Exit Sub
Cancel = True
If MsgBox("Do you want to insert a new row below this row?", vbYesNo) = vbYes Then
Target.Resize(1, 14).AutoFill Destination:=Range(Target, Target.Offset(1, 13)), Type:=xlFillDefault
Target.Offset(1, 0).Resize(1, 2).ClearContents
Target.Offset(1, 1).Resize(1, 2).ClearContents
End If
LR = Empty
End Sub

I have set the marcos but tried to incorporate both requirements inside but it doesn't work as I still new to macros.
Would appreciate your assistance on this form. Thank you.