i need to append the odd row data into even and delete the row
===

I need to append data of the alternate row like D1+D2 into excel, please tell mw how can i do that

I have big excel and i am looking for a VBA so that i can append the odd row data into even row and devel the odd row. 

    		Surgical		Surgical
    10	$1,800	Unit	8/5/2011	unit
    		Surgical		Surgical
    10	$4,000	Unit	9/2/2011	unit
    		Surgical		Surgical
    10	$2,000	Unit	8/12/2011	unit
    		Surgical		Surgical
    10	$1,250	Unit	8/12/2011	unit
    		Surgical		Surgical
    10	$1,517	Unit	8/19/2011	unit
    		Surgical		Surgical
    10	$1,250	Unit	8/19/2011	unit
    		Surgical		Surgical
    10	$2,000	Unit	8/12/2011	unit
    		Surgical		Surgical
    10	$2,200	Unit	8/19/2011	unit
    		Surgical		Surgical
    10	$0	Unit	8/19/2011	unit
    		Surgical		Surgical
    10	$1,251	Unit	8/12/2011	unit
    		Surgical		Surgical
    10	$1,500	Unit	8/12/2011	unit
    		Surgical		Surgical
    10	$1,001	Unit	9/1/2011	unit


these are in two cell and i wand to add the data into upper one 
please help me with that

thanks in advance