Adding Up Columns Code Needed

[bamaisgreat]

I have a spreadsheet that is generated by Auto Cad Electrical. When I get the raw data I would like to run a macro from my personal workbook that will do the following:
For each Cell in Column B that is empty, I would like to have the data in the adjacent cell in Column C be moved to Column B.
Then in column D I need Column A + Column C + Column D with a space in between each to be combined.

Hope this makes sense and as always thanks for your help.

 

[ravishankar]

try the following codes

Sub alabama()
Dim x As Long, a As Long
x = Cells(Rows.Count, 1).End(xlUp).Row
MsgBox x
    For a = 2 To x
        If Cells(a, 2) = "" Then
        Range("C" & a).Copy
        Range("B" & a).PasteSpecial
        Range("C" & a) = ""
        End If
    Cells(a, 4) = Cells(a, 1) & " " & Cells(a, 3) & " " & Cells(a, 4)
    Next a
MsgBox "complete"
End Sub

ravishankar