Combine two columns

[irshaid]

hi
I wana combine to columns with Macro
A B C D E F G H
[TABLE="width: 796"]
<tbody>[TR]
[TD]A001[/TD]
[TD]310399.166[/TD]
[TD]1.0[/TD]
[TD][/TD]
[TD]YE[/TD]
[TD]B1[/TD]
[TD]A[/TD]
[TD]-79X215-11-1[/TD]
[TD]-XK65-X342/188[/TD]
[/TR]
[TR]
[TD]A001[/TD]
[TD]310399.166[/TD]
[TD]1.0[/TD]
[TD][/TD]
[TD]YE[/TD]
[TD]B1[/TD]
[TD]A[/TD]
[TD]-79X215-11-1[/TD]
[TD]-XK65-X342/188[/TD]
[/TR]
</tbody>[/TABLE]

the result should be like
A B C D E F G
[TABLE="width: 796"]
<tbody>[TR]
[TD]A001[/TD]
[TD]310399.166[/TD]
[TD]1.0[/TD]
[TD][/TD]
[TD]YE[/TD]
[TD]B1[/TD]
[TD]A[/TD]
[TD]-79X215-11-1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A001[/TD]
[TD]310399.166[/TD]
[TD]1.0[/TD]
[TD][/TD]
[TD]YE[/TD]
[TD]B1[/TD]
[TD]A[/TD]
[TD]-XK65-X342/188[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance