excel vba that moves over merged cells

[BORUCH]

hi all

i have a data set that looks like below

Book1
	A	B	C	D	E	F	G	H	I	J
1	Item #	Description	qty	price	qty	price	qty	price	qty	price
2	00000	test 1	10	$12.00	20	$11.00	30	$10.00
3	00001	test 2
4	00002	test 3
5
6	00004	test 5	9	$13.00	25	$9.00
7	00005	test 6
8	00006	test 7
9
10	00008	test 9	10	$14.00	20	$15.66	30	$14.00	40	$13.00
Sheet1

i would like an excel vba that does this below

Book1
	M	N	O	P	Q	R	S	T	U	V	W	X
1	Item #	Description	qty	price	qty	price	qty	price	qty	price
2	00000	test 1	10	$12.00	20	$11.00			30	$10.00
3	00001	test 2
4	00002	test 3
5
6	00004	test 5	10	$13.00			25	$9.00
7	00005	test 6
8	00006	test 7
9
10	00008	test 9	10	$14.00	20	$15.66	30	$14.00			40	$13.00
Sheet1

as you can see it moved over every group to the right

any suggestions is greatly appreciated

 

[jolivanes]

I guess that's why it says "Change as required".
Anyway, you have it sorted so all the best with it and have a Happy, Healthy and Prosperous New Year.
Good Luck