Merge two columns to one

[abberyfarm]

Hi there,

I have zeros is Column A and Column B and they are always on different rows. Would somebody know a macro to either merge Columns A and B into Column C like below or else place a 0 in Column C if there is a 0 in Column A or B.

Thank You

Excel Workbook
	A	B	C
1	A	B	C
2	0		0
3		0	0
4
5	0		0
6		0	0
7
8	0		0
9		0	0
10	0		0
11	0		0
12		0	0
Sheet1

 

[VoG]

Perhaps

Sub test()
Dim LR As Long, i As Long
LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
For i = 1 To LR
    If Range("A" & i).Value <> "" Or Range("B" & i).Value <> "" Then Range("C" & i).Value = 0
Next i
End Sub

 

[abberyfarm]

Hi,

Thank you - works perfect!

 

[Marcol]

You could also do this without a macro
=IF(COUNTIF(A2:B2,0)>0,0,"")
Drag/Fill Down

Copy and Paste > Paste Special > Values