Example in
A1:a100 = a,v,c,d,w,1,2,4,aa etc
In b1 = a,b5 = v ,b6:b7 ="",b8 = c
Insert value in col b according data in col a,with copy to col b every 4 row and 2 row after 4 is empty
Become 4,2,4,2,4,2
Example get data from col a copy to col b
Become b1=a1(if not empty A1),a4=b2(if not empty b2),a5:a6="",a7=b3(if not empty b3),a8:a9=""..etc
Bookmarks